Overview
Brought to you by YData
Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 7381 |
| Missing cells | 195949 |
| Missing cells (%) | 54.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.7 MiB |
| Average record size in memory | 384.0 B |
Variable types
| Text | 8 |
|---|---|
| Numeric | 14 |
| DateTime | 6 |
| Boolean | 5 |
| Categorical | 16 |
preventTargetGapPoints has constant value "True" | Constant |
userFlaggedNewItem has constant value "True" | Constant |
pointsNotAwardedReason has constant value "Action not allowed for user and CPG" | Constant |
deleted has constant value "True" | Constant |
competitiveProduct is highly overall correlated with competitorRewardsGroup and 16 other fields | High correlation |
competitorRewardsGroup is highly overall correlated with competitiveProduct and 8 other fields | High correlation |
discountedItemPrice is highly overall correlated with competitiveProduct and 9 other fields | High correlation |
finalPrice is highly overall correlated with competitiveProduct and 18 other fields | High correlation |
hours_diff is highly overall correlated with competitorRewardsGroup and 12 other fields | High correlation |
itemNumber is highly overall correlated with competitiveProduct and 18 other fields | High correlation |
itemPrice is highly overall correlated with discountedItemPrice and 14 other fields | High correlation |
items_in_receipt_list is highly overall correlated with hours_diff and 17 other fields | High correlation |
minutes_diff is highly overall correlated with competitorRewardsGroup and 12 other fields | High correlation |
needsFetchReview is highly overall correlated with competitorRewardsGroup and 16 other fields | High correlation |
needsFetchReviewReason is highly overall correlated with competitiveProduct and 17 other fields | High correlation |
originalFinalPrice is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
originalMetaBriteBarcode is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
originalMetaBriteDescription is highly overall correlated with finalPrice and 21 other fields | High correlation |
originalMetaBriteItemPrice is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
originalMetaBriteQuantityPurchased is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
partnerItemId is highly overall correlated with competitiveProduct and 14 other fields | High correlation |
pointsEarned is highly overall correlated with competitiveProduct and 18 other fields | High correlation |
pointsPayerId is highly overall correlated with finalPrice and 15 other fields | High correlation |
priceAfterCoupon is highly overall correlated with competitiveProduct and 5 other fields | High correlation |
purchasedItemCount is highly overall correlated with hours_diff and 17 other fields | High correlation |
quantityPurchased is highly overall correlated with itemNumber and 7 other fields | High correlation |
rewardsProductPartnerId is highly overall correlated with competitiveProduct and 16 other fields | High correlation |
summary_list_difference_count is highly overall correlated with competitorRewardsGroup and 12 other fields | High correlation |
targetPrice is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
total_receipt_points_earned is highly overall correlated with hours_diff and 11 other fields | High correlation |
total_receipt_spent is highly overall correlated with hours_diff and 17 other fields | High correlation |
userFlaggedBarcode is highly overall correlated with competitiveProduct and 21 other fields | High correlation |
userFlaggedDescription is highly overall correlated with finalPrice and 17 other fields | High correlation |
userFlaggedPrice is highly overall correlated with competitiveProduct and 19 other fields | High correlation |
userFlaggedQuantity is highly overall correlated with competitiveProduct and 17 other fields | High correlation |
needsFetchReviewReason is highly imbalanced (77.4%) | Imbalance |
purchasedItemCount has 484 (6.6%) missing values | Missing |
finisheddate has 1411 (19.1%) missing values | Missing |
pointsawardeddate has 1301 (17.6%) missing values | Missing |
purchasedate has 458 (6.2%) missing values | Missing |
total_receipt_points_earned has 1128 (15.3%) missing values | Missing |
total_receipt_spent has 435 (5.9%) missing values | Missing |
barcode has 4291 (58.1%) missing values | Missing |
description has 821 (11.1%) missing values | Missing |
finalPrice has 614 (8.3%) missing values | Missing |
itemPrice has 614 (8.3%) missing values | Missing |
needsFetchReview has 6568 (89.0%) missing values | Missing |
partnerItemId has 440 (6.0%) missing values | Missing |
preventTargetGapPoints has 7023 (95.1%) missing values | Missing |
quantityPurchased has 614 (8.3%) missing values | Missing |
userFlaggedBarcode has 7044 (95.4%) missing values | Missing |
userFlaggedNewItem has 7058 (95.6%) missing values | Missing |
userFlaggedPrice has 7082 (95.9%) missing values | Missing |
userFlaggedQuantity has 7082 (95.9%) missing values | Missing |
needsFetchReviewReason has 7162 (97.0%) missing values | Missing |
pointsNotAwardedReason has 7041 (95.4%) missing values | Missing |
pointsPayerId has 6114 (82.8%) missing values | Missing |
rewardsGroup has 5650 (76.5%) missing values | Missing |
rewardsProductPartnerId has 5112 (69.3%) missing values | Missing |
userFlaggedDescription has 7176 (97.2%) missing values | Missing |
originalMetaBriteBarcode has 7310 (99.0%) missing values | Missing |
originalMetaBriteDescription has 7371 (99.9%) missing values | Missing |
brandCode has 4781 (64.8%) missing values | Missing |
competitorRewardsGroup has 7106 (96.3%) missing values | Missing |
discountedItemPrice has 1612 (21.8%) missing values | Missing |
originalReceiptItemText has 1621 (22.0%) missing values | Missing |
itemNumber has 7228 (97.9%) missing values | Missing |
originalMetaBriteQuantityPurchased has 7366 (99.8%) missing values | Missing |
pointsEarned has 6454 (87.4%) missing values | Missing |
targetPrice has 7003 (94.9%) missing values | Missing |
competitiveProduct has 6736 (91.3%) missing values | Missing |
originalFinalPrice has 7372 (99.9%) missing values | Missing |
originalMetaBriteItemPrice has 7372 (99.9%) missing values | Missing |
deleted has 7372 (99.9%) missing values | Missing |
priceAfterCoupon has 6425 (87.0%) missing values | Missing |
metabriteCampaignId has 6518 (88.3%) missing values | Missing |
items_in_receipt_list has 464 (6.3%) missing values | Missing |
summary_list_difference_count has 513 (7.0%) missing values | Missing |
hours_diff has 1301 (17.6%) missing values | Missing |
minutes_diff has 1301 (17.6%) missing values | Missing |
receipt_item_id has unique values | Unique |
partnerItemId has 145 (2.0%) zeros | Zeros |
summary_list_difference_count has 6756 (91.5%) zeros | Zeros |
hours_diff has 439 (5.9%) zeros | Zeros |
minutes_diff has 439 (5.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-04 04:56:57.447466 |
|---|---|
| Analysis finished | 2025-02-04 05:02:01.983846 |
| Duration | 5 minutes and 4.54 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
receipt_id
Text
| Distinct | 1119 |
|---|---|
| Distinct (%) | 15.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.8 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Unique
| Unique | 817 ? |
|---|---|
| Unique (%) | 11.1% |
Sample
| 1st row | 5ff1e1cd0a720f052300056f |
|---|---|
| 2nd row | 5ff5d1f20a720f05230005db |
| 3rd row | 5ff5d1f20a720f05230005db |
| 4th row | 5ff5d1f20a720f05230005db |
| 5th row | 5ff5d1f20a720f05230005db |
| Value | Count | Frequency (%) |
| 600f2fc80a720f0535000030 | 459 | 6.2% |
| 600f39c30a7214ada2000030 | 450 | 6.1% |
| 600f24970a720f053500002f | 381 | 5.2% |
| 600f0cc70a720f053500002c | 217 | 2.9% |
| 600a1a8d0a7214ada2000008 | 203 | 2.8% |
| 60049d9d0a720f05f3000094 | 194 | 2.6% |
| 60025cb80a720f05f300008d | 185 | 2.5% |
| 600260210a720f05f300008f | 183 | 2.5% |
| 600a1e270a720f0535000009 | 176 | 2.4% |
| 600edb570a720f053500001d | 155 | 2.1% |
| Other values (1109) | 4778 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 62005 | |
| a | 15529 | 8.8% |
| 2 | 14350 | 8.1% |
| f | 11783 | 6.7% |
| 7 | 10142 | 5.7% |
| 5 | 9317 | 5.3% |
| 6 | 8434 | 4.8% |
| 3 | 8155 | 4.6% |
| 1 | 6774 | 3.8% |
| 4 | 6027 | 3.4% |
| Other values (6) | 24628 | 13.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 177144 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62005 | |
| a | 15529 | 8.8% |
| 2 | 14350 | 8.1% |
| f | 11783 | 6.7% |
| 7 | 10142 | 5.7% |
| 5 | 9317 | 5.3% |
| 6 | 8434 | 4.8% |
| 3 | 8155 | 4.6% |
| 1 | 6774 | 3.8% |
| 4 | 6027 | 3.4% |
| Other values (6) | 24628 | 13.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 177144 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62005 | |
| a | 15529 | 8.8% |
| 2 | 14350 | 8.1% |
| f | 11783 | 6.7% |
| 7 | 10142 | 5.7% |
| 5 | 9317 | 5.3% |
| 6 | 8434 | 4.8% |
| 3 | 8155 | 4.6% |
| 1 | 6774 | 3.8% |
| 4 | 6027 | 3.4% |
| Other values (6) | 24628 | 13.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 177144 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62005 | |
| a | 15529 | 8.8% |
| 2 | 14350 | 8.1% |
| f | 11783 | 6.7% |
| 7 | 10142 | 5.7% |
| 5 | 9317 | 5.3% |
| 6 | 8434 | 4.8% |
| 3 | 8155 | 4.6% |
| 1 | 6774 | 3.8% |
| 4 | 6027 | 3.4% |
| Other values (6) | 24628 | 13.9% |
purchasedItemCount
Real number (ℝ)
High correlation  Missing 
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 484 |
| Missing (%) | 6.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240.76468 |
| Minimum | 0 |
|---|---|
| Maximum | 689 |
| Zeros | 25 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 93 |
| median | 167 |
| Q3 | 335 |
| 95-th percentile | 689 |
| Maximum | 689 |
| Range | 689 |
| Interquartile range (IQR) | 242 |
Descriptive statistics
| Standard deviation | 221.80545 |
|---|---|
| Coefficient of variation (CV) | 0.92125412 |
| Kurtosis | -0.29312694 |
| Mean | 240.76468 |
| Median Absolute Deviation (MAD) | 136 |
| Skewness | 0.96073798 |
| Sum | 1660554 |
| Variance | 49197.659 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 689 | 459 | 6.2% |
| 670 | 450 | 6.1% |
| 599 | 381 | 5.2% |
| 5 | 370 | 5.0% |
| 1 | 325 | 4.4% |
| 133 | 248 | 3.4% |
| 303 | 217 | 2.9% |
| 2 | 212 | 2.9% |
| 214 | 203 | 2.8% |
| 212 | 194 | 2.6% |
| Other values (40) | 3838 | |
| (Missing) | 484 | 6.6% |
| Value | Count | Frequency (%) |
| 0 | 25 | 0.3% |
| 1 | 325 | |
| 2 | 212 | |
| 3 | 32 | 0.4% |
| 4 | 157 | |
| 5 | 370 | |
| 6 | 23 | 0.3% |
| 7 | 15 | 0.2% |
| 8 | 2 | < 0.1% |
| 9 | 90 | 1.2% |
| Value | Count | Frequency (%) |
| 689 | 459 | |
| 670 | 450 | |
| 599 | 381 | |
| 348 | 127 | 1.7% |
| 341 | 124 | 1.7% |
| 335 | 185 | |
| 309 | 183 | 2.5% |
| 303 | 217 | |
| 240 | 148 | 2.0% |
| 229 | 99 | 1.3% |
createdate
Date
| Distinct | 1107 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.8 KiB |
| Minimum | 2020-10-30 20:17:59 |
|---|---|
| Maximum | 2021-03-01 23:17:34.772000 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
datescanned
Date
| Distinct | 1107 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.8 KiB |
| Minimum | 2020-10-30 20:17:59 |
|---|---|
| Maximum | 2021-03-01 23:17:34.772000 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
finisheddate
Date
Missing 
| Distinct | 553 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 1411 |
| Missing (%) | 19.1% |
| Memory size | 57.8 KiB |
| Minimum | 2021-01-03 15:24:10 |
|---|---|
| Maximum | 2021-02-26 22:36:25 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
modifydate
Date
| Distinct | 1104 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.8 KiB |
| Minimum | 2021-01-03 15:24:10 |
|---|---|
| Maximum | 2021-03-01 23:17:34.772000 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Missing 
| Distinct | 523 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 1301 |
| Missing (%) | 17.6% |
| Memory size | 57.8 KiB |
| Minimum | 2020-10-30 20:18:00 |
|---|---|
| Maximum | 2021-02-26 22:36:25 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
purchasedate
Date
Missing 
| Distinct | 358 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 458 |
| Missing (%) | 6.2% |
| Memory size | 57.8 KiB |
| Minimum | 2017-10-30 00:00:00 |
|---|---|
| Maximum | 2021-03-08 17:37:13 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
total_receipt_points_earned
Real number (ℝ)
High correlation  Missing 
| Distinct | 119 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1128 |
| Missing (%) | 15.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2175.5837 |
| Minimum | 0 |
|---|---|
| Maximum | 10199.8 |
| Zeros | 6 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 750 |
| median | 1447 |
| Q3 | 2685.8 |
| 95-th percentile | 7137.2002 |
| Maximum | 10199.8 |
| Range | 10199.8 |
| Interquartile range (IQR) | 1935.8 |
Descriptive statistics
| Standard deviation | 2175.7334 |
|---|---|
| Coefficient of variation (CV) | 1.0000688 |
| Kurtosis | 0.76142293 |
| Mean | 2175.5837 |
| Median Absolute Deviation (MAD) | 841.29999 |
| Skewness | 1.3340405 |
| Sum | 13603925 |
| Variance | 4733815.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4944.700195 | 459 | 6.2% |
| 7137.200195 | 450 | 6.1% |
| 750 | 342 | 4.6% |
| 5 | 298 | 4.0% |
| 1178.699951 | 203 | 2.8% |
| 922.0999756 | 194 | 2.6% |
| 1658.300049 | 185 | 2.5% |
| 3659.399902 | 183 | 2.5% |
| 1135.099976 | 176 | 2.4% |
| 487.7000122 | 155 | 2.1% |
| Other values (109) | 3608 | |
| (Missing) | 1128 | 15.3% |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.1% |
| 5 | 298 | |
| 25 | 104 | 1.4% |
| 35 | 7 | 0.1% |
| 50 | 27 | 0.4% |
| 50.59999847 | 5 | 0.1% |
| 50.90000153 | 1 | < 0.1% |
| 55 | 22 | 0.3% |
| 91.19999695 | 8 | 0.1% |
| 94.59999847 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 10199.7998 | 2 | < 0.1% |
| 9850 | 1 | < 0.1% |
| 9449.799805 | 11 | 0.1% |
| 9200 | 10 | 0.1% |
| 8950 | 10 | 0.1% |
| 8850 | 10 | 0.1% |
| 8700 | 30 | 0.4% |
| 7137.200195 | 450 | |
| 6257.299805 | 127 | 1.7% |
| 5850 | 2 | < 0.1% |
total_receipt_spent
Real number (ℝ)
High correlation  Missing 
| Distinct | 94 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 435 |
| Missing (%) | 5.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1368.5772 |
| Minimum | 0 |
|---|---|
| Maximum | 4721.9502 |
| Zeros | 25 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 29.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 373.54999 |
| median | 776.78998 |
| Q3 | 1183.1 |
| 95-th percentile | 4721.9502 |
| Maximum | 4721.9502 |
| Range | 4721.9502 |
| Interquartile range (IQR) | 809.54999 |
Descriptive statistics
| Standard deviation | 1588.9594 |
|---|---|
| Coefficient of variation (CV) | 1.1610301 |
| Kurtosis | 0.20020902 |
| Mean | 1368.5772 |
| Median Absolute Deviation (MAD) | 406.31 |
| Skewness | 1.3484646 |
| Sum | 9506137.3 |
| Variance | 2524791.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4566.169922 | 459 | 6.2% |
| 4721.950195 | 450 | 6.1% |
| 4368.799805 | 381 | 5.2% |
| 1 | 324 | 4.4% |
| 2084.820068 | 217 | 2.9% |
| 49.95000076 | 215 | 2.9% |
| 1183.099976 | 203 | 2.8% |
| 743.789978 | 194 | 2.6% |
| 1177.839966 | 185 | 2.5% |
| 1043.180054 | 183 | 2.5% |
| Other values (84) | 4135 | |
| (Missing) | 435 | 5.9% |
| Value | Count | Frequency (%) |
| 0 | 25 | 0.3% |
| 0.1599999964 | 1 | < 0.1% |
| 0.9900000095 | 7 | 0.1% |
| 1 | 324 | |
| 2 | 8 | 0.1% |
| 2.230000019 | 7 | 0.1% |
| 2.289999962 | 1 | < 0.1% |
| 2.99000001 | 1 | < 0.1% |
| 3 | 18 | 0.2% |
| 3.089999914 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 4721.950195 | 450 | |
| 4566.169922 | 459 | |
| 4368.799805 | 381 | |
| 2084.820068 | 217 | |
| 1198.680054 | 127 | 1.7% |
| 1183.099976 | 203 | |
| 1177.839966 | 185 | |
| 1107.819946 | 125 | 1.7% |
| 1083.23999 | 124 | 1.7% |
| 1043.180054 | 183 | 2.5% |
barcode
Text
Missing 
| Distinct | 568 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 4291 |
| Missing (%) | 58.1% |
| Memory size | 57.8 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 11.067314 |
| Min length | 2 |
Unique
| Unique | 261 ? |
|---|---|
| Unique (%) | 8.4% |
Sample
| 1st row | 021000051113 |
|---|---|
| 2nd row | 021000051113 |
| 3rd row | 021000051113 |
| 4th row | 021000051113 |
| 5th row | 043000204399 |
| Value | Count | Frequency (%) |
| 4011 | 177 | 5.7% |
| 036000320893 | 92 | 3.0% |
| 034100573065 | 90 | 2.9% |
| 036000391718 | 87 | 2.8% |
| 012000809941 | 76 | 2.5% |
| 076840580750 | 63 | 2.0% |
| 041000022623 | 54 | 1.7% |
| 076840100354 | 53 | 1.7% |
| 028400642033 | 45 | 1.5% |
| 311111511867 | 41 | 1.3% |
| Other values (558) | 2312 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11212 | |
| 1 | 4353 | 12.7% |
| 4 | 3087 | 9.0% |
| 3 | 2690 | 7.9% |
| 2 | 2582 | 7.6% |
| 5 | 2310 | 6.8% |
| 7 | 2083 | 6.1% |
| 6 | 2026 | 5.9% |
| 8 | 1890 | 5.5% |
| 9 | 1471 | 4.3% |
| Other values (14) | 494 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34198 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11212 | |
| 1 | 4353 | 12.7% |
| 4 | 3087 | 9.0% |
| 3 | 2690 | 7.9% |
| 2 | 2582 | 7.6% |
| 5 | 2310 | 6.8% |
| 7 | 2083 | 6.1% |
| 6 | 2026 | 5.9% |
| 8 | 1890 | 5.5% |
| 9 | 1471 | 4.3% |
| Other values (14) | 494 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34198 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11212 | |
| 1 | 4353 | 12.7% |
| 4 | 3087 | 9.0% |
| 3 | 2690 | 7.9% |
| 2 | 2582 | 7.6% |
| 5 | 2310 | 6.8% |
| 7 | 2083 | 6.1% |
| 6 | 2026 | 5.9% |
| 8 | 1890 | 5.5% |
| 9 | 1471 | 4.3% |
| Other values (14) | 494 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34198 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11212 | |
| 1 | 4353 | 12.7% |
| 4 | 3087 | 9.0% |
| 3 | 2690 | 7.9% |
| 2 | 2582 | 7.6% |
| 5 | 2310 | 6.8% |
| 7 | 2083 | 6.1% |
| 6 | 2026 | 5.9% |
| 8 | 1890 | 5.5% |
| 9 | 1471 | 4.3% |
| Other values (14) | 494 | 1.4% |
description
Text
Missing 
| Distinct | 1889 |
|---|---|
| Distinct (%) | 28.8% |
| Missing | 821 |
| Missing (%) | 11.1% |
| Memory size | 57.8 KiB |
Length
| Max length | 155 |
|---|---|
| Median length | 92 |
| Mean length | 29.15122 |
| Min length | 2 |
Unique
| Unique | 1136 ? |
|---|---|
| Unique (%) | 17.3% |
Sample
| 1st row | MSSN TORTLLA |
|---|---|
| 2nd row | Jell-O Instant Pudding & Pie Filling French Vanilla, 3.4 Oz |
| 3rd row | ITEM NOT FOUND |
| 4th row | VASELINE COCOA BUTTER SKIN MOISTURIZER LOTION CONDITIONING RP 34.5 OZ |
| 5th row | ITEM NOT FOUND |
| Value | Count | Frequency (%) |
| oz | 1209 | 3.5% |
| 931 | 2.7% | |
| cheese | 327 | 1.0% |
| 12 | 321 | 0.9% |
| bag | 276 | 0.8% |
| hyv | 246 | 0.7% |
| can | 241 | 0.7% |
| ct | 237 | 0.7% |
| regular | 215 | 0.6% |
| fl | 211 | 0.6% |
| Other values (3183) | 30149 |
Most occurring characters
| Value | Count | Frequency (%) |
| 27810 | 14.5% | |
| E | 8222 | 4.3% |
| e | 7865 | 4.1% |
| R | 7158 | 3.7% |
| C | 6724 | 3.5% |
| S | 6612 | 3.5% |
| A | 6575 | 3.4% |
| L | 6297 | 3.3% |
| O | 6266 | 3.3% |
| N | 5520 | 2.9% |
| Other values (73) | 102183 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 191232 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 27810 | 14.5% | |
| E | 8222 | 4.3% |
| e | 7865 | 4.1% |
| R | 7158 | 3.7% |
| C | 6724 | 3.5% |
| S | 6612 | 3.5% |
| A | 6575 | 3.4% |
| L | 6297 | 3.3% |
| O | 6266 | 3.3% |
| N | 5520 | 2.9% |
| Other values (73) | 102183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 191232 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 27810 | 14.5% | |
| E | 8222 | 4.3% |
| e | 7865 | 4.1% |
| R | 7158 | 3.7% |
| C | 6724 | 3.5% |
| S | 6612 | 3.5% |
| A | 6575 | 3.4% |
| L | 6297 | 3.3% |
| O | 6266 | 3.3% |
| N | 5520 | 2.9% |
| Other values (73) | 102183 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 191232 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 27810 | 14.5% | |
| E | 8222 | 4.3% |
| e | 7865 | 4.1% |
| R | 7158 | 3.7% |
| C | 6724 | 3.5% |
| S | 6612 | 3.5% |
| A | 6575 | 3.4% |
| L | 6297 | 3.3% |
| O | 6266 | 3.3% |
| N | 5520 | 2.9% |
| Other values (73) | 102183 |
finalPrice
Real number (ℝ)
High correlation  Missing 
| Distinct | 823 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 614 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.871661 |
| Minimum | 0 |
|---|---|
| Maximum | 441.58 |
| Zeros | 4 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.56 |
| Q1 | 2.29 |
| median | 4.28 |
| Q3 | 9.99 |
| 95-th percentile | 26 |
| Maximum | 441.58 |
| Range | 441.58 |
| Interquartile range (IQR) | 7.7 |
Descriptive statistics
| Standard deviation | 14.656776 |
|---|---|
| Coefficient of variation (CV) | 1.8619674 |
| Kurtosis | 207.38946 |
| Mean | 7.871661 |
| Median Absolute Deviation (MAD) | 2.7 |
| Skewness | 11.383034 |
| Sum | 53267.53 |
| Variance | 214.82108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 375 | 5.1% |
| 9.99 | 355 | 4.8% |
| 3.99 | 243 | 3.3% |
| 4.99 | 195 | 2.6% |
| 0.56 | 190 | 2.6% |
| 2.99 | 179 | 2.4% |
| 5.99 | 176 | 2.4% |
| 3.49 | 139 | 1.9% |
| 2.34 | 134 | 1.8% |
| 5 | 124 | 1.7% |
| Other values (813) | 4657 | |
| (Missing) | 614 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.19 | 13 | 0.2% |
| 0.25 | 2 | < 0.1% |
| 0.32 | 2 | < 0.1% |
| 0.48 | 3 | < 0.1% |
| 0.5 | 76 | 1.0% |
| 0.54 | 66 | 0.9% |
| 0.55 | 2 | < 0.1% |
| 0.56 | 190 |
| Value | Count | Frequency (%) |
| 441.58 | 1 | < 0.1% |
| 245 | 3 | |
| 223.36 | 5 | |
| 180 | 6 | |
| 168.84 | 5 | |
| 115.96 | 1 | < 0.1% |
| 100.48 | 1 | < 0.1% |
| 100 | 6 | |
| 95.84 | 4 | |
| 82.34 | 1 | < 0.1% |
itemPrice
Real number (ℝ)
High correlation  Missing 
| Distinct | 823 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 614 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8721782 |
| Minimum | 0 |
|---|---|
| Maximum | 441.58 |
| Zeros | 4 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.56 |
| Q1 | 2.29 |
| median | 4.28 |
| Q3 | 9.99 |
| 95-th percentile | 26 |
| Maximum | 441.58 |
| Range | 441.58 |
| Interquartile range (IQR) | 7.7 |
Descriptive statistics
| Standard deviation | 14.656623 |
|---|---|
| Coefficient of variation (CV) | 1.8618256 |
| Kurtosis | 207.39662 |
| Mean | 7.8721782 |
| Median Absolute Deviation (MAD) | 2.7 |
| Skewness | 11.383294 |
| Sum | 53271.03 |
| Variance | 214.8166 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 375 | 5.1% |
| 9.99 | 355 | 4.8% |
| 3.99 | 243 | 3.3% |
| 4.99 | 196 | 2.7% |
| 0.56 | 190 | 2.6% |
| 2.99 | 180 | 2.4% |
| 5.99 | 176 | 2.4% |
| 3.49 | 139 | 1.9% |
| 2.34 | 134 | 1.8% |
| 5 | 124 | 1.7% |
| Other values (813) | 4655 | |
| (Missing) | 614 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.19 | 13 | 0.2% |
| 0.25 | 2 | < 0.1% |
| 0.32 | 2 | < 0.1% |
| 0.48 | 3 | < 0.1% |
| 0.5 | 76 | 1.0% |
| 0.54 | 66 | 0.9% |
| 0.55 | 2 | < 0.1% |
| 0.56 | 190 |
| Value | Count | Frequency (%) |
| 441.58 | 1 | < 0.1% |
| 245 | 3 | |
| 223.36 | 5 | |
| 180 | 6 | |
| 168.84 | 5 | |
| 115.96 | 1 | < 0.1% |
| 100.48 | 1 | < 0.1% |
| 100 | 6 | |
| 95.84 | 4 | |
| 82.34 | 1 | < 0.1% |
needsFetchReview
Boolean
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 6568 |
| Missing (%) | 89.0% |
| Memory size | 57.8 KiB |
| False | 594 |
|---|---|
| True | 219 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 594 | 8.0% |
| True | 219 | 3.0% |
| (Missing) | 6568 |
partnerItemId
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 916 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 440 |
| Missing (%) | 6.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 988.52428 |
| Minimum | 0 |
|---|---|
| Maximum | 2043 |
| Zeros | 145 |
| Zeros (%) | 2.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1027 |
| median | 1143 |
| Q3 | 1274 |
| 95-th percentile | 1644 |
| Maximum | 2043 |
| Range | 2043 |
| Interquartile range (IQR) | 247 |
Descriptive statistics
| Standard deviation | 527.38082 |
|---|---|
| Coefficient of variation (CV) | 0.53350316 |
| Kurtosis | -0.13640789 |
| Mean | 988.52428 |
| Median Absolute Deviation (MAD) | 123 |
| Skewness | -1.0174858 |
| Sum | 6861347 |
| Variance | 278130.53 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 531 | 7.2% |
| 2 | 203 | 2.8% |
| 0 | 145 | 2.0% |
| 3 | 135 | 1.8% |
| 4 | 113 | 1.5% |
| 5 | 106 | 1.4% |
| 7 | 34 | 0.5% |
| 8 | 34 | 0.5% |
| 6 | 34 | 0.5% |
| 9 | 34 | 0.5% |
| Other values (906) | 5572 | |
| (Missing) | 440 | 6.0% |
| Value | Count | Frequency (%) |
| 0 | 145 | 2.0% |
| 1 | 531 | |
| 2 | 203 | 2.8% |
| 3 | 135 | 1.8% |
| 4 | 113 | 1.5% |
| 5 | 106 | 1.4% |
| 6 | 34 | 0.5% |
| 7 | 34 | 0.5% |
| 8 | 34 | 0.5% |
| 9 | 34 | 0.5% |
| Value | Count | Frequency (%) |
| 2043 | 1 | |
| 2040 | 1 | |
| 2036 | 1 | |
| 2033 | 1 | |
| 2029 | 1 | |
| 2026 | 1 | |
| 1986 | 1 | |
| 1983 | 1 | |
| 1980 | 1 | |
| 1976 | 1 |
preventTargetGapPoints
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7023 |
| Missing (%) | 95.1% |
| Memory size | 57.8 KiB |
| True | 358 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 358 | 4.9% |
| (Missing) | 7023 |
quantityPurchased
Real number (ℝ)
High correlation  Missing 
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 614 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3861386 |
| Minimum | 1 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 17 |
| Range | 16 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.2043632 |
|---|---|
| Coefficient of variation (CV) | 0.86886201 |
| Kurtosis | 36.002117 |
| Mean | 1.3861386 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1137362 |
| Sum | 9380 |
| Variance | 1.4504907 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 5628 | |
| 2 | 622 | 8.4% |
| 4 | 170 | 2.3% |
| 3 | 134 | 1.8% |
| 5 | 101 | 1.4% |
| 6 | 37 | 0.5% |
| 8 | 22 | 0.3% |
| 10 | 15 | 0.2% |
| 7 | 13 | 0.2% |
| 9 | 13 | 0.2% |
| Other values (3) | 12 | 0.2% |
| (Missing) | 614 | 8.3% |
| Value | Count | Frequency (%) |
| 1 | 5628 | |
| 2 | 622 | 8.4% |
| 3 | 134 | 1.8% |
| 4 | 170 | 2.3% |
| 5 | 101 | 1.4% |
| 6 | 37 | 0.5% |
| 7 | 13 | 0.2% |
| 8 | 22 | 0.3% |
| 9 | 13 | 0.2% |
| 10 | 15 | 0.2% |
| Value | Count | Frequency (%) |
| 17 | 3 | < 0.1% |
| 14 | 3 | < 0.1% |
| 12 | 6 | 0.1% |
| 10 | 15 | 0.2% |
| 9 | 13 | 0.2% |
| 8 | 22 | 0.3% |
| 7 | 13 | 0.2% |
| 6 | 37 | 0.5% |
| 5 | 101 | |
| 4 | 170 |
userFlaggedBarcode
Categorical
High correlation  Missing 
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 7044 |
| Missing (%) | 95.4% |
| Memory size | 57.8 KiB |
| 034100573065 | |
|---|---|
| 4011 | |
| 1234 | |
| 028400642255 | 13 |
| 079400066619 | 10 |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 8.7002967 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1234 |
|---|---|
| 2nd row | 034100573065 |
| 3rd row | 034100573065 |
| 4th row | 034100573065 |
| 5th row | 034100573065 |
Common Values
| Value | Count | Frequency (%) |
| 034100573065 | 166 | 2.2% |
| 4011 | 107 | 1.4% |
| 1234 | 32 | 0.4% |
| 028400642255 | 13 | 0.2% |
| 079400066619 | 10 | 0.1% |
| 075925306254 | 9 | 0.1% |
| (Missing) | 7044 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 034100573065 | 166 | |
| 4011 | 107 | |
| 1234 | 32 | 9.5% |
| 028400642255 | 13 | 3.9% |
| 079400066619 | 10 | 3.0% |
| 075925306254 | 9 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 868 | |
| 1 | 422 | |
| 5 | 385 | |
| 3 | 373 | |
| 4 | 350 | |
| 6 | 218 | 7.4% |
| 7 | 185 | 6.3% |
| 2 | 89 | 3.0% |
| 9 | 29 | 1.0% |
| 8 | 13 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2932 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 868 | |
| 1 | 422 | |
| 5 | 385 | |
| 3 | 373 | |
| 4 | 350 | |
| 6 | 218 | 7.4% |
| 7 | 185 | 6.3% |
| 2 | 89 | 3.0% |
| 9 | 29 | 1.0% |
| 8 | 13 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2932 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 868 | |
| 1 | 422 | |
| 5 | 385 | |
| 3 | 373 | |
| 4 | 350 | |
| 6 | 218 | 7.4% |
| 7 | 185 | 6.3% |
| 2 | 89 | 3.0% |
| 9 | 29 | 1.0% |
| 8 | 13 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2932 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 868 | |
| 1 | 422 | |
| 5 | 385 | |
| 3 | 373 | |
| 4 | 350 | |
| 6 | 218 | 7.4% |
| 7 | 185 | 6.3% |
| 2 | 89 | 3.0% |
| 9 | 29 | 1.0% |
| 8 | 13 | 0.4% |
userFlaggedNewItem
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7058 |
| Missing (%) | 95.6% |
| Memory size | 57.8 KiB |
| True | 323 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 323 | 4.4% |
| (Missing) | 7058 |
userFlaggedPrice
Categorical
High correlation  Missing 
| Distinct | 13 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 7082 |
| Missing (%) | 95.9% |
| Memory size | 57.8 KiB |
| 29.00 | |
|---|---|
| 1.00 | |
| 10.00 | |
| 28.00 | |
| 21.00 | 14 |
| Other values (8) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.8862876 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 29.00 |
|---|---|
| 2nd row | 29.00 |
| 3rd row | 29.00 |
| 4th row | 29.00 |
| 5th row | 29.00 |
Common Values
| Value | Count | Frequency (%) |
| 29.00 | 142 | 1.9% |
| 1.00 | 26 | 0.4% |
| 10.00 | 22 | 0.3% |
| 28.00 | 15 | 0.2% |
| 21.00 | 14 | 0.2% |
| 20.00 | 14 | 0.2% |
| 27.00 | 13 | 0.2% |
| 25.00 | 10 | 0.1% |
| 23.00 | 10 | 0.1% |
| 26.00 | 10 | 0.1% |
| Other values (3) | 23 | 0.3% |
| (Missing) | 7082 |
Length
| Value | Count | Frequency (%) |
| 29.00 | 142 | |
| 1.00 | 26 | 8.7% |
| 10.00 | 22 | 7.4% |
| 28.00 | 15 | 5.0% |
| 21.00 | 14 | 4.7% |
| 20.00 | 14 | 4.7% |
| 27.00 | 13 | 4.3% |
| 25.00 | 10 | 3.3% |
| 23.00 | 10 | 3.3% |
| 26.00 | 10 | 3.3% |
| Other values (3) | 23 | 7.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 618 | |
| . | 299 | |
| 2 | 260 | |
| 9 | 142 | 9.7% |
| 1 | 62 | 4.2% |
| 5 | 18 | 1.2% |
| 6 | 18 | 1.2% |
| 8 | 15 | 1.0% |
| 7 | 13 | 0.9% |
| 3 | 10 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1461 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 618 | |
| . | 299 | |
| 2 | 260 | |
| 9 | 142 | 9.7% |
| 1 | 62 | 4.2% |
| 5 | 18 | 1.2% |
| 6 | 18 | 1.2% |
| 8 | 15 | 1.0% |
| 7 | 13 | 0.9% |
| 3 | 10 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1461 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 618 | |
| . | 299 | |
| 2 | 260 | |
| 9 | 142 | 9.7% |
| 1 | 62 | 4.2% |
| 5 | 18 | 1.2% |
| 6 | 18 | 1.2% |
| 8 | 15 | 1.0% |
| 7 | 13 | 0.9% |
| 3 | 10 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1461 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 618 | |
| . | 299 | |
| 2 | 260 | |
| 9 | 142 | 9.7% |
| 1 | 62 | 4.2% |
| 5 | 18 | 1.2% |
| 6 | 18 | 1.2% |
| 8 | 15 | 1.0% |
| 7 | 13 | 0.9% |
| 3 | 10 | 0.7% |
userFlaggedQuantity
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 7082 |
| Missing (%) | 95.9% |
| Memory size | 57.8 KiB |
| 1.0 | |
|---|---|
| 3.0 | |
| 4.0 | |
| 2.0 | |
| 5.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 189 | 2.6% |
| 3.0 | 31 | 0.4% |
| 4.0 | 30 | 0.4% |
| 2.0 | 29 | 0.4% |
| 5.0 | 20 | 0.3% |
| (Missing) | 7082 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 189 | |
| 3.0 | 31 | 10.4% |
| 4.0 | 30 | 10.0% |
| 2.0 | 29 | 9.7% |
| 5.0 | 20 | 6.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 299 | |
| 0 | 299 | |
| 1 | 189 | |
| 3 | 31 | 3.5% |
| 4 | 30 | 3.3% |
| 2 | 29 | 3.2% |
| 5 | 20 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 897 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 299 | |
| 0 | 299 | |
| 1 | 189 | |
| 3 | 31 | 3.5% |
| 4 | 30 | 3.3% |
| 2 | 29 | 3.2% |
| 5 | 20 | 2.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 897 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 299 | |
| 0 | 299 | |
| 1 | 189 | |
| 3 | 31 | 3.5% |
| 4 | 30 | 3.3% |
| 2 | 29 | 3.2% |
| 5 | 20 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 897 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 299 | |
| 0 | 299 | |
| 1 | 189 | |
| 3 | 31 | 3.5% |
| 4 | 30 | 3.3% |
| 2 | 29 | 3.2% |
| 5 | 20 | 2.2% |
needsFetchReviewReason
Categorical
High correlation  Imbalance  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 7162 |
| Missing (%) | 97.0% |
| Memory size | 57.8 KiB |
| USER_FLAGGED | |
|---|---|
| POINTS_GREATER_THAN_THRESHOLD | 8 |
Length
| Max length | 29 |
|---|---|
| Median length | 12 |
| Mean length | 12.621005 |
| Min length | 12 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USER_FLAGGED |
|---|---|
| 2nd row | USER_FLAGGED |
| 3rd row | USER_FLAGGED |
| 4th row | USER_FLAGGED |
| 5th row | USER_FLAGGED |
Common Values
| Value | Count | Frequency (%) |
| USER_FLAGGED | 211 | 2.9% |
| POINTS_GREATER_THAN_THRESHOLD | 8 | 0.1% |
| (Missing) | 7162 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| user_flagged | 211 | |
| points_greater_than_threshold | 8 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 446 | |
| G | 430 | |
| R | 235 | |
| _ | 235 | |
| S | 227 | |
| A | 227 | |
| L | 219 | |
| D | 219 | |
| U | 211 | |
| F | 211 | |
| Other values (6) | 104 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 446 | |
| G | 430 | |
| R | 235 | |
| _ | 235 | |
| S | 227 | |
| A | 227 | |
| L | 219 | |
| D | 219 | |
| U | 211 | |
| F | 211 | |
| Other values (6) | 104 | 3.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 446 | |
| G | 430 | |
| R | 235 | |
| _ | 235 | |
| S | 227 | |
| A | 227 | |
| L | 219 | |
| D | 219 | |
| U | 211 | |
| F | 211 | |
| Other values (6) | 104 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 446 | |
| G | 430 | |
| R | 235 | |
| _ | 235 | |
| S | 227 | |
| A | 227 | |
| L | 219 | |
| D | 219 | |
| U | 211 | |
| F | 211 | |
| Other values (6) | 104 | 3.8% |
pointsNotAwardedReason
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7041 |
| Missing (%) | 95.4% |
| Memory size | 57.8 KiB |
| Action not allowed for user and CPG |
|---|
Length
| Max length | 35 |
|---|---|
| Median length | 35 |
| Mean length | 35 |
| Min length | 35 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Action not allowed for user and CPG |
|---|---|
| 2nd row | Action not allowed for user and CPG |
| 3rd row | Action not allowed for user and CPG |
| 4th row | Action not allowed for user and CPG |
| 5th row | Action not allowed for user and CPG |
Common Values
| Value | Count | Frequency (%) |
| Action not allowed for user and CPG | 340 | 4.6% |
| (Missing) | 7041 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| action | 340 | |
| not | 340 | |
| allowed | 340 | |
| for | 340 | |
| user | 340 | |
| and | 340 | |
| cpg | 340 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2040 | ||
| o | 1360 | |
| n | 1020 | 8.6% |
| t | 680 | 5.7% |
| a | 680 | 5.7% |
| l | 680 | 5.7% |
| e | 680 | 5.7% |
| d | 680 | 5.7% |
| r | 680 | 5.7% |
| A | 340 | 2.9% |
| Other values (9) | 3060 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11900 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2040 | ||
| o | 1360 | |
| n | 1020 | 8.6% |
| t | 680 | 5.7% |
| a | 680 | 5.7% |
| l | 680 | 5.7% |
| e | 680 | 5.7% |
| d | 680 | 5.7% |
| r | 680 | 5.7% |
| A | 340 | 2.9% |
| Other values (9) | 3060 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11900 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2040 | ||
| o | 1360 | |
| n | 1020 | 8.6% |
| t | 680 | 5.7% |
| a | 680 | 5.7% |
| l | 680 | 5.7% |
| e | 680 | 5.7% |
| d | 680 | 5.7% |
| r | 680 | 5.7% |
| A | 340 | 2.9% |
| Other values (9) | 3060 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11900 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2040 | ||
| o | 1360 | |
| n | 1020 | 8.6% |
| t | 680 | 5.7% |
| a | 680 | 5.7% |
| l | 680 | 5.7% |
| e | 680 | 5.7% |
| d | 680 | 5.7% |
| r | 680 | 5.7% |
| A | 340 | 2.9% |
| Other values (9) | 3060 |
pointsPayerId
Categorical
High correlation  Missing 
| Distinct | 15 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 6114 |
| Missing (%) | 82.8% |
| Memory size | 57.8 KiB |
| 559c2234e4b06aca36af13c6 | |
|---|---|
| 5332f5f6e4b03c9a25efd0b4 | |
| 5332f5fbe4b03c9a25efd0ba | |
| 550b2565e4b001d5e9e4146f | |
| 5332f709e4b03c9a25efd0f1 | |
| Other values (10) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 5332f5f6e4b03c9a25efd0b4 |
|---|---|
| 2nd row | 5332f5f3e4b03c9a25efd0ae |
| 3rd row | 5332f5f6e4b03c9a25efd0b4 |
| 4th row | 5332f5fbe4b03c9a25efd0ba |
| 5th row | 5332f5fbe4b03c9a25efd0ba |
Common Values
| Value | Count | Frequency (%) |
| 559c2234e4b06aca36af13c6 | 331 | 4.5% |
| 5332f5f6e4b03c9a25efd0b4 | 281 | 3.8% |
| 5332f5fbe4b03c9a25efd0ba | 230 | 3.1% |
| 550b2565e4b001d5e9e4146f | 190 | 2.6% |
| 5332f709e4b03c9a25efd0f1 | 90 | 1.2% |
| 5332f5f3e4b03c9a25efd0ae | 56 | 0.8% |
| 5a734034e4b0d58f376be874 | 31 | 0.4% |
| 5e825d64f221c312e698a62a | 25 | 0.3% |
| 5eebc5412455c97a877ef382 | 24 | 0.3% |
| 53e10d6368abd3c7065097cc | 3 | < 0.1% |
| Other values (5) | 6 | 0.1% |
| (Missing) | 6114 |
Length
| Value | Count | Frequency (%) |
| 559c2234e4b06aca36af13c6 | 331 | |
| 5332f5f6e4b03c9a25efd0b4 | 281 | |
| 5332f5fbe4b03c9a25efd0ba | 230 | |
| 550b2565e4b001d5e9e4146f | 190 | |
| 5332f709e4b03c9a25efd0f1 | 90 | 7.1% |
| 5332f5f3e4b03c9a25efd0ae | 56 | 4.4% |
| 5a734034e4b0d58f376be874 | 31 | 2.4% |
| 5e825d64f221c312e698a62a | 25 | 2.0% |
| 5eebc5412455c97a877ef382 | 24 | 1.9% |
| 53e10d6368abd3c7065097cc | 3 | 0.2% |
| Other values (5) | 6 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 3716 | |
| 3 | 3180 | |
| f | 2586 | |
| e | 2470 | |
| 0 | 2384 | |
| 4 | 2369 | |
| 2 | 2352 | |
| b | 2205 | |
| a | 2049 | 6.7% |
| 6 | 1780 | 5.9% |
| Other values (6) | 5317 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30408 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 3716 | |
| 3 | 3180 | |
| f | 2586 | |
| e | 2470 | |
| 0 | 2384 | |
| 4 | 2369 | |
| 2 | 2352 | |
| b | 2205 | |
| a | 2049 | 6.7% |
| 6 | 1780 | 5.9% |
| Other values (6) | 5317 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30408 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 3716 | |
| 3 | 3180 | |
| f | 2586 | |
| e | 2470 | |
| 0 | 2384 | |
| 4 | 2369 | |
| 2 | 2352 | |
| b | 2205 | |
| a | 2049 | 6.7% |
| 6 | 1780 | 5.9% |
| Other values (6) | 5317 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30408 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 3716 | |
| 3 | 3180 | |
| f | 2586 | |
| e | 2470 | |
| 0 | 2384 | |
| 4 | 2369 | |
| 2 | 2352 | |
| b | 2205 | |
| a | 2049 | 6.7% |
| 6 | 1780 | 5.9% |
| Other values (6) | 5317 |
rewardsGroup
Text
Missing 
| Distinct | 182 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 5650 |
| Missing (%) | 76.5% |
| Memory size | 57.8 KiB |
Length
| Max length | 66 |
|---|---|
| Median length | 45 |
| Mean length | 30.23859 |
| Min length | 7 |
Unique
| Unique | 78 ? |
|---|---|
| Unique (%) | 4.5% |
Sample
| 1st row | SARGENTO GRATED PARMESAN CHEESE |
|---|---|
| 2nd row | SARGENTO GRATED PARMESAN CHEESE |
| 3rd row | SARGENTO GRATED PARMESAN CHEESE |
| 4th row | SARGENTO GRATED PARMESAN CHEESE |
| 5th row | VASELINE HAND AND BODY LOTION |
| Value | Count | Frequency (%) |
| and | 306 | 3.4% |
| cheese | 296 | 3.3% |
| pack | 279 | 3.1% |
| 249 | 2.7% | |
| count | 221 | 2.4% |
| or | 215 | 2.4% |
| larger | 207 | 2.3% |
| 12 | 193 | 2.1% |
| ice | 184 | 2.0% |
| cream | 184 | 2.0% |
| Other values (386) | 6768 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7371 | ||
| E | 6109 | 11.7% |
| A | 3592 | 6.9% |
| R | 3561 | 6.8% |
| S | 3452 | 6.6% |
| I | 2772 | 5.3% |
| N | 2751 | 5.3% |
| C | 2534 | 4.8% |
| O | 2388 | 4.6% |
| L | 2113 | 4.0% |
| Other values (36) | 15700 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 52343 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7371 | ||
| E | 6109 | 11.7% |
| A | 3592 | 6.9% |
| R | 3561 | 6.8% |
| S | 3452 | 6.6% |
| I | 2772 | 5.3% |
| N | 2751 | 5.3% |
| C | 2534 | 4.8% |
| O | 2388 | 4.6% |
| L | 2113 | 4.0% |
| Other values (36) | 15700 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 52343 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7371 | ||
| E | 6109 | 11.7% |
| A | 3592 | 6.9% |
| R | 3561 | 6.8% |
| S | 3452 | 6.6% |
| I | 2772 | 5.3% |
| N | 2751 | 5.3% |
| C | 2534 | 4.8% |
| O | 2388 | 4.6% |
| L | 2113 | 4.0% |
| Other values (36) | 15700 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 52343 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7371 | ||
| E | 6109 | 11.7% |
| A | 3592 | 6.9% |
| R | 3561 | 6.8% |
| S | 3452 | 6.6% |
| I | 2772 | 5.3% |
| N | 2751 | 5.3% |
| C | 2534 | 4.8% |
| O | 2388 | 4.6% |
| L | 2113 | 4.0% |
| Other values (36) | 15700 |
rewardsProductPartnerId
Categorical
High correlation  Missing 
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 5112 |
| Missing (%) | 69.3% |
| Memory size | 57.8 KiB |
| 559c2234e4b06aca36af13c6 | |
|---|---|
| 5332f5f6e4b03c9a25efd0b4 | |
| 5332f5fbe4b03c9a25efd0ba | |
| 550b2565e4b001d5e9e4146f | |
| 5332f5f3e4b03c9a25efd0ae | |
| Other values (11) |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 5e7cf838f221c312e698a628 |
|---|---|
| 2nd row | 5e7cf838f221c312e698a628 |
| 3rd row | 5e7cf838f221c312e698a628 |
| 4th row | 5e7cf838f221c312e698a628 |
| 5th row | 559c2234e4b06aca36af13c6 |
Common Values
| Value | Count | Frequency (%) |
| 559c2234e4b06aca36af13c6 | 878 | 11.9% |
| 5332f5f6e4b03c9a25efd0b4 | 315 | 4.3% |
| 5332f5fbe4b03c9a25efd0ba | 243 | 3.3% |
| 550b2565e4b001d5e9e4146f | 202 | 2.7% |
| 5332f5f3e4b03c9a25efd0ae | 181 | 2.5% |
| 5e7cf838f221c312e698a628 | 157 | 2.1% |
| 5e825d64f221c312e698a62a | 124 | 1.7% |
| 5332f709e4b03c9a25efd0f1 | 92 | 1.2% |
| 5a734034e4b0d58f376be874 | 31 | 0.4% |
| 5eebc5412455c97a877ef382 | 24 | 0.3% |
| Other values (6) | 22 | 0.3% |
| (Missing) | 5112 |
Length
| Value | Count | Frequency (%) |
| 559c2234e4b06aca36af13c6 | 878 | |
| 5332f5f6e4b03c9a25efd0b4 | 315 | 13.9% |
| 5332f5fbe4b03c9a25efd0ba | 243 | 10.7% |
| 550b2565e4b001d5e9e4146f | 202 | 8.9% |
| 5332f5f3e4b03c9a25efd0ae | 181 | 8.0% |
| 5e7cf838f221c312e698a628 | 157 | 6.9% |
| 5e825d64f221c312e698a62a | 124 | 5.5% |
| 5332f709e4b03c9a25efd0f1 | 92 | 4.1% |
| 5a734034e4b0d58f376be874 | 31 | 1.4% |
| 5eebc5412455c97a877ef382 | 24 | 1.1% |
| Other values (6) | 22 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 5885 | |
| 5 | 5784 | |
| 2 | 4971 | |
| a | 4393 | |
| 6 | 4111 | |
| f | 4093 | |
| e | 4049 | |
| c | 3988 | 7.3% |
| 4 | 3824 | 7.0% |
| 0 | 3324 | 6.1% |
| Other values (6) | 10034 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54456 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 5885 | |
| 5 | 5784 | |
| 2 | 4971 | |
| a | 4393 | |
| 6 | 4111 | |
| f | 4093 | |
| e | 4049 | |
| c | 3988 | 7.3% |
| 4 | 3824 | 7.0% |
| 0 | 3324 | 6.1% |
| Other values (6) | 10034 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54456 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 5885 | |
| 5 | 5784 | |
| 2 | 4971 | |
| a | 4393 | |
| 6 | 4111 | |
| f | 4093 | |
| e | 4049 | |
| c | 3988 | 7.3% |
| 4 | 3824 | 7.0% |
| 0 | 3324 | 6.1% |
| Other values (6) | 10034 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54456 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 5885 | |
| 5 | 5784 | |
| 2 | 4971 | |
| a | 4393 | |
| 6 | 4111 | |
| f | 4093 | |
| e | 4049 | |
| c | 3988 | 7.3% |
| 4 | 3824 | 7.0% |
| 0 | 3324 | 6.1% |
| Other values (6) | 10034 |
userFlaggedDescription
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 7176 |
| Missing (%) | 97.2% |
| Memory size | 57.8 KiB |
| MILLER LITE 24 PACK 12OZ CAN | |
|---|---|
| DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ | 7 |
Length
| Max length | 60 |
|---|---|
| Median length | 28 |
| Mean length | 22.126829 |
| Min length | 0 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | MILLER LITE 24 PACK 12OZ CAN |
| 3rd row | MILLER LITE 24 PACK 12OZ CAN |
| 4th row | MILLER LITE 24 PACK 12OZ CAN |
| 5th row | MILLER LITE 24 PACK 12OZ CAN |
Common Values
| Value | Count | Frequency (%) |
| MILLER LITE 24 PACK 12OZ CAN | 147 | 2.0% |
| 51 | 0.7% | |
| DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ | 7 | 0.1% |
| (Missing) | 7176 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| miller | 147 | |
| 24 | 147 | |
| pack | 147 | |
| 12oz | 147 | |
| can | 147 | |
| lite | 147 | |
| chili | 7 | 0.7% |
| 1 | 7 | 0.7% |
| bag | 7 | 0.7% |
| fat | 7 | 0.7% |
| Other values (7) | 49 | 5.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 805 | ||
| L | 462 | 10.2% |
| I | 336 | 7.4% |
| E | 322 | 7.1% |
| C | 322 | 7.1% |
| A | 315 | 6.9% |
| 2 | 294 | 6.5% |
| T | 182 | 4.0% |
| O | 175 | 3.9% |
| R | 168 | 3.7% |
| Other values (16) | 1155 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4536 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 805 | ||
| L | 462 | 10.2% |
| I | 336 | 7.4% |
| E | 322 | 7.1% |
| C | 322 | 7.1% |
| A | 315 | 6.9% |
| 2 | 294 | 6.5% |
| T | 182 | 4.0% |
| O | 175 | 3.9% |
| R | 168 | 3.7% |
| Other values (16) | 1155 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4536 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 805 | ||
| L | 462 | 10.2% |
| I | 336 | 7.4% |
| E | 322 | 7.1% |
| C | 322 | 7.1% |
| A | 315 | 6.9% |
| 2 | 294 | 6.5% |
| T | 182 | 4.0% |
| O | 175 | 3.9% |
| R | 168 | 3.7% |
| Other values (16) | 1155 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4536 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 805 | ||
| L | 462 | 10.2% |
| I | 336 | 7.4% |
| E | 322 | 7.1% |
| C | 322 | 7.1% |
| A | 315 | 6.9% |
| 2 | 294 | 6.5% |
| T | 182 | 4.0% |
| O | 175 | 3.9% |
| R | 168 | 3.7% |
| Other values (16) | 1155 |
originalMetaBriteBarcode
Categorical
High correlation  Missing 
| Distinct | 6 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 7310 |
| Missing (%) | 99.0% |
| Memory size | 57.8 KiB |
| 080878042197 | |
|---|---|
| 034100573065 | |
| 028400642255 | 4 |
| 075925306254 | 3 |
Length
| Max length | 12 |
|---|---|
| Median length | 0 |
| Mean length | 4.056338 |
| Min length | 0 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | 028400642255 |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 47 | 0.6% | |
| 080878042197 | 10 | 0.1% |
| 034100573065 | 6 | 0.1% |
| 028400642255 | 4 | 0.1% |
| 075925306254 | 3 | < 0.1% |
| 002900001903 | 1 | < 0.1% |
| (Missing) | 7310 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 080878042197 | 10 | |
| 034100573065 | 6 | |
| 028400642255 | 4 | 16.7% |
| 075925306254 | 3 | 12.5% |
| 002900001903 | 1 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 8 | 34 | |
| 7 | 29 | 10.1% |
| 2 | 29 | 10.1% |
| 5 | 29 | 10.1% |
| 4 | 27 | 9.4% |
| 1 | 17 | 5.9% |
| 3 | 16 | 5.6% |
| 9 | 15 | 5.2% |
| 6 | 13 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 288 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 8 | 34 | |
| 7 | 29 | 10.1% |
| 2 | 29 | 10.1% |
| 5 | 29 | 10.1% |
| 4 | 27 | 9.4% |
| 1 | 17 | 5.9% |
| 3 | 16 | 5.6% |
| 9 | 15 | 5.2% |
| 6 | 13 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 288 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 8 | 34 | |
| 7 | 29 | 10.1% |
| 2 | 29 | 10.1% |
| 5 | 29 | 10.1% |
| 4 | 27 | 9.4% |
| 1 | 17 | 5.9% |
| 3 | 16 | 5.6% |
| 9 | 15 | 5.2% |
| 6 | 13 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 288 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 8 | 34 | |
| 7 | 29 | 10.1% |
| 2 | 29 | 10.1% |
| 5 | 29 | 10.1% |
| 4 | 27 | 9.4% |
| 1 | 17 | 5.9% |
| 3 | 16 | 5.6% |
| 9 | 15 | 5.2% |
| 6 | 13 | 4.5% |
originalMetaBriteDescription
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 7371 |
| Missing (%) | 99.9% |
| Memory size | 57.8 KiB |
| MILLER LITE 24 PACK 12OZ CAN | |
|---|---|
| DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ |
Length
| Max length | 60 |
|---|---|
| Median length | 28 |
| Mean length | 40.8 |
| Min length | 28 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ |
|---|---|
| 2nd row | MILLER LITE 24 PACK 12OZ CAN |
| 3rd row | MILLER LITE 24 PACK 12OZ CAN |
| 4th row | DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ |
| 5th row | DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ |
Common Values
| Value | Count | Frequency (%) |
| MILLER LITE 24 PACK 12OZ CAN | 6 | 0.1% |
| DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ | 4 | 0.1% |
| (Missing) | 7371 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| miller | 6 | 7.5% |
| 24 | 6 | 7.5% |
| pack | 6 | 7.5% |
| 12oz | 6 | 7.5% |
| can | 6 | 7.5% |
| lite | 6 | 7.5% |
| chili | 4 | 5.0% |
| 1 | 4 | 5.0% |
| bag | 4 | 5.0% |
| fat | 4 | 5.0% |
| Other values (7) | 28 |
Most occurring characters
| Value | Count | Frequency (%) |
| 70 | ||
| I | 36 | 8.8% |
| L | 30 | 7.4% |
| E | 28 | 6.9% |
| C | 28 | 6.9% |
| T | 26 | 6.4% |
| A | 24 | 5.9% |
| O | 22 | 5.4% |
| R | 18 | 4.4% |
| P | 14 | 3.4% |
| Other values (16) | 112 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 408 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 70 | ||
| I | 36 | 8.8% |
| L | 30 | 7.4% |
| E | 28 | 6.9% |
| C | 28 | 6.9% |
| T | 26 | 6.4% |
| A | 24 | 5.9% |
| O | 22 | 5.4% |
| R | 18 | 4.4% |
| P | 14 | 3.4% |
| Other values (16) | 112 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 408 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 70 | ||
| I | 36 | 8.8% |
| L | 30 | 7.4% |
| E | 28 | 6.9% |
| C | 28 | 6.9% |
| T | 26 | 6.4% |
| A | 24 | 5.9% |
| O | 22 | 5.4% |
| R | 18 | 4.4% |
| P | 14 | 3.4% |
| Other values (16) | 112 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 408 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 70 | ||
| I | 36 | 8.8% |
| L | 30 | 7.4% |
| E | 28 | 6.9% |
| C | 28 | 6.9% |
| T | 26 | 6.4% |
| A | 24 | 5.9% |
| O | 22 | 5.4% |
| R | 18 | 4.4% |
| P | 14 | 3.4% |
| Other values (16) | 112 |
brandCode
Text
Missing 
| Distinct | 227 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 4781 |
| Missing (%) | 64.8% |
| Memory size | 57.8 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 23 |
| Mean length | 9.24 |
| Min length | 2 |
Unique
| Unique | 58 ? |
|---|---|
| Unique (%) | 2.2% |
Sample
| 1st row | MISSION |
|---|---|
| 2nd row | BRAND |
| 3rd row | TIC TAC |
| 4th row | WONDERFUL |
| 5th row | RICE-A-RONI |
| Value | Count | Frequency (%) |
| hy-vee | 299 | 7.5% |
| ben | 180 | 4.5% |
| and | 180 | 4.5% |
| jerrys | 180 | 4.5% |
| pepsi | 93 | 2.3% |
| kroger | 89 | 2.2% |
| kleenex | 88 | 2.2% |
| knorr | 79 | 2.0% |
| doritos | 77 | 1.9% |
| borden | 71 | 1.8% |
| Other values (308) | 2632 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 3252 | |
| R | 2016 | 8.4% |
| S | 1594 | 6.6% |
| A | 1433 | 6.0% |
| N | 1424 | 5.9% |
| 1368 | 5.7% | |
| I | 1289 | 5.4% |
| L | 1232 | 5.1% |
| O | 1194 | 5.0% |
| T | 1102 | 4.6% |
| Other values (26) | 8120 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24024 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 3252 | |
| R | 2016 | 8.4% |
| S | 1594 | 6.6% |
| A | 1433 | 6.0% |
| N | 1424 | 5.9% |
| 1368 | 5.7% | |
| I | 1289 | 5.4% |
| L | 1232 | 5.1% |
| O | 1194 | 5.0% |
| T | 1102 | 4.6% |
| Other values (26) | 8120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24024 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 3252 | |
| R | 2016 | 8.4% |
| S | 1594 | 6.6% |
| A | 1433 | 6.0% |
| N | 1424 | 5.9% |
| 1368 | 5.7% | |
| I | 1289 | 5.4% |
| L | 1232 | 5.1% |
| O | 1194 | 5.0% |
| T | 1102 | 4.6% |
| Other values (26) | 8120 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24024 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 3252 | |
| R | 2016 | 8.4% |
| S | 1594 | 6.6% |
| A | 1433 | 6.0% |
| N | 1424 | 5.9% |
| 1368 | 5.7% | |
| I | 1289 | 5.4% |
| L | 1232 | 5.1% |
| O | 1194 | 5.0% |
| T | 1102 | 4.6% |
| Other values (26) | 8120 |
competitorRewardsGroup
Categorical
High correlation  Missing 
| Distinct | 30 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 7106 |
| Missing (%) | 96.3% |
| Memory size | 57.8 KiB |
| OSCAR MAYER SAUSAGE LINK | |
|---|---|
| MAXWELL HOUSE GROUND COFFEE | |
| A.1. DRY RUB | |
| OSCAR MAYER BACON | |
| TACO BELL TACO SHELLS | |
| Other values (25) |
Length
| Max length | 47 |
|---|---|
| Median length | 32 |
| Mean length | 21.418182 |
| Min length | 10 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 2.5% |
Sample
| 1st row | TACO BELL TACO SHELLS |
|---|---|
| 2nd row | PLANTERS PISTACHIOS |
| 3rd row | SMART ONES |
| 4th row | MAXWELL HOUSE GROUND COFFEE |
| 5th row | FOOD NETWORK KITCHEN INSPIRATIONS COOKING SAUCE |
Common Values
| Value | Count | Frequency (%) |
| OSCAR MAYER SAUSAGE LINK | 43 | 0.6% |
| MAXWELL HOUSE GROUND COFFEE | 36 | 0.5% |
| A.1. DRY RUB | 29 | 0.4% |
| OSCAR MAYER BACON | 24 | 0.3% |
| TACO BELL TACO SHELLS | 21 | 0.3% |
| LIPTON TEA | 20 | 0.3% |
| T.G.I. FRIDAY'S FROZEN APPETIZER | 13 | 0.2% |
| CAPRI SUN BEVERAGE DRINK | 13 | 0.2% |
| SMART ONES | 11 | 0.1% |
| FOOD NETWORK KITCHEN INSPIRATIONS COOKING SAUCE | 10 | 0.1% |
| Other values (20) | 55 | 0.7% |
| (Missing) | 7106 |
Length
| Value | Count | Frequency (%) |
| oscar | 71 | 7.2% |
| mayer | 71 | 7.2% |
| sausage | 43 | 4.4% |
| link | 43 | 4.4% |
| taco | 42 | 4.3% |
| coffee | 38 | 3.9% |
| maxwell | 36 | 3.7% |
| house | 36 | 3.7% |
| ground | 36 | 3.7% |
| a.1 | 29 | 2.9% |
| Other values (77) | 539 |
Most occurring characters
| Value | Count | Frequency (%) |
| 709 | ||
| A | 562 | 9.5% |
| E | 560 | 9.5% |
| O | 415 | 7.0% |
| S | 415 | 7.0% |
| R | 393 | 6.7% |
| C | 292 | 5.0% |
| N | 276 | 4.7% |
| L | 249 | 4.2% |
| I | 248 | 4.2% |
| Other values (25) | 1771 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5890 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 709 | ||
| A | 562 | 9.5% |
| E | 560 | 9.5% |
| O | 415 | 7.0% |
| S | 415 | 7.0% |
| R | 393 | 6.7% |
| C | 292 | 5.0% |
| N | 276 | 4.7% |
| L | 249 | 4.2% |
| I | 248 | 4.2% |
| Other values (25) | 1771 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5890 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 709 | ||
| A | 562 | 9.5% |
| E | 560 | 9.5% |
| O | 415 | 7.0% |
| S | 415 | 7.0% |
| R | 393 | 6.7% |
| C | 292 | 5.0% |
| N | 276 | 4.7% |
| L | 249 | 4.2% |
| I | 248 | 4.2% |
| Other values (25) | 1771 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5890 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 709 | ||
| A | 562 | 9.5% |
| E | 560 | 9.5% |
| O | 415 | 7.0% |
| S | 415 | 7.0% |
| R | 393 | 6.7% |
| C | 292 | 5.0% |
| N | 276 | 4.7% |
| L | 249 | 4.2% |
| I | 248 | 4.2% |
| Other values (25) | 1771 |
discountedItemPrice
Real number (ℝ)
High correlation  Missing 
| Distinct | 817 |
|---|---|
| Distinct (%) | 14.2% |
| Missing | 1612 |
| Missing (%) | 21.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6643664 |
| Minimum | 0.16 |
|---|---|
| Maximum | 441.58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0.16 |
|---|---|
| 5-th percentile | 0.56 |
| Q1 | 2.34 |
| median | 3.99 |
| Q3 | 7.96 |
| 95-th percentile | 22.97 |
| Maximum | 441.58 |
| Range | 441.42 |
| Interquartile range (IQR) | 5.62 |
Descriptive statistics
| Standard deviation | 15.463778 |
|---|---|
| Coefficient of variation (CV) | 2.0176199 |
| Kurtosis | 196.739 |
| Mean | 7.6643664 |
| Median Absolute Deviation (MAD) | 2.19 |
| Skewness | 11.362894 |
| Sum | 44215.73 |
| Variance | 239.12844 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.99 | 243 | 3.3% |
| 4.99 | 196 | 2.7% |
| 0.56 | 190 | 2.6% |
| 2.99 | 179 | 2.4% |
| 5.99 | 176 | 2.4% |
| 3.49 | 139 | 1.9% |
| 2.34 | 134 | 1.8% |
| 2.49 | 106 | 1.4% |
| 1.99 | 98 | 1.3% |
| 1 | 94 | 1.3% |
| Other values (807) | 4214 | |
| (Missing) | 1612 | 21.8% |
| Value | Count | Frequency (%) |
| 0.16 | 1 | < 0.1% |
| 0.19 | 13 | 0.2% |
| 0.25 | 2 | < 0.1% |
| 0.32 | 2 | < 0.1% |
| 0.48 | 3 | < 0.1% |
| 0.5 | 76 | 1.0% |
| 0.54 | 66 | 0.9% |
| 0.55 | 2 | < 0.1% |
| 0.56 | 190 | |
| 0.58 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 441.58 | 1 | < 0.1% |
| 245 | 3 | |
| 223.36 | 5 | |
| 180 | 6 | |
| 168.84 | 5 | |
| 115.96 | 1 | < 0.1% |
| 100.48 | 1 | < 0.1% |
| 100 | 6 | |
| 95.84 | 4 | |
| 82.34 | 1 | < 0.1% |
Missing 
| Distinct | 1738 |
|---|---|
| Distinct (%) | 30.2% |
| Missing | 1621 |
| Missing (%) | 22.0% |
| Memory size | 57.8 KiB |
Length
| Max length | 155 |
|---|---|
| Median length | 60 |
| Mean length | 19.377083 |
| Min length | 4 |
Unique
| Unique | 1123 ? |
|---|---|
| Unique (%) | 19.5% |
Sample
| 1st row | MSSN TORTLLA |
|---|---|
| 2nd row | flipbelt level terrain waist pouch, neon yellow, large/32-35 |
| 3rd row | flipbelt level terrain waist pouch, neon yellow, large/32-35 |
| 4th row | TC NCTN GUM 2MG COOL |
| 5th row | WNDRFL RSTD&SALTED |
| Value | Count | Frequency (%) |
| hyv | 429 | 2.1% |
| oz | 284 | 1.4% |
| 12 | 233 | 1.2% |
| s | 231 | 1.1% |
| 216 | 1.1% | |
| ben | 196 | 1.0% |
| cheese | 170 | 0.8% |
| sausage | 156 | 0.8% |
| lf | 150 | 0.7% |
| milk | 150 | 0.7% |
| Other values (2393) | 17961 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14418 | 12.9% | |
| E | 8283 | 7.4% |
| S | 6105 | 5.5% |
| A | 5668 | 5.1% |
| R | 5635 | 5.0% |
| L | 5146 | 4.6% |
| C | 4744 | 4.3% |
| O | 4697 | 4.2% |
| N | 4576 | 4.1% |
| I | 4167 | 3.7% |
| Other values (69) | 48173 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 111612 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 14418 | 12.9% | |
| E | 8283 | 7.4% |
| S | 6105 | 5.5% |
| A | 5668 | 5.1% |
| R | 5635 | 5.0% |
| L | 5146 | 4.6% |
| C | 4744 | 4.3% |
| O | 4697 | 4.2% |
| N | 4576 | 4.1% |
| I | 4167 | 3.7% |
| Other values (69) | 48173 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 111612 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 14418 | 12.9% | |
| E | 8283 | 7.4% |
| S | 6105 | 5.5% |
| A | 5668 | 5.1% |
| R | 5635 | 5.0% |
| L | 5146 | 4.6% |
| C | 4744 | 4.3% |
| O | 4697 | 4.2% |
| N | 4576 | 4.1% |
| I | 4167 | 3.7% |
| Other values (69) | 48173 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 111612 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 14418 | 12.9% | |
| E | 8283 | 7.4% |
| S | 6105 | 5.5% |
| A | 5668 | 5.1% |
| R | 5635 | 5.0% |
| L | 5146 | 4.6% |
| C | 4744 | 4.3% |
| O | 4697 | 4.2% |
| N | 4576 | 4.1% |
| I | 4167 | 3.7% |
| Other values (69) | 48173 |
itemNumber
Categorical
High correlation  Missing 
| Distinct | 47 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 7228 |
| Missing (%) | 97.9% |
| Memory size | 57.8 KiB |
| 4023 | |
|---|---|
| 013562300631 | 6 |
| 036000162905 | 5 |
| 078742112138 | 2 |
| 4011 | 2 |
| Other values (42) |
Length
| Max length | 12 |
|---|---|
| Median length | 4 |
| Mean length | 7.0326797 |
| Min length | 4 |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | 24.8% |
Sample
| 1st row | 4023 |
|---|---|
| 2nd row | 4023 |
| 3rd row | 4023 |
| 4th row | 4023 |
| 5th row | 000980000069 |
Common Values
| Value | Count | Frequency (%) |
| 4023 | 92 | 1.2% |
| 013562300631 | 6 | 0.1% |
| 036000162905 | 5 | 0.1% |
| 078742112138 | 2 | < 0.1% |
| 4011 | 2 | < 0.1% |
| 021000040247 | 2 | < 0.1% |
| 078742333960 | 2 | < 0.1% |
| 037466017631 | 2 | < 0.1% |
| 085718300512 | 2 | < 0.1% |
| 052100587967 | 1 | < 0.1% |
| Other values (37) | 37 | 0.5% |
| (Missing) | 7228 |
Length
| Value | Count | Frequency (%) |
| 4023 | 92 | |
| 013562300631 | 6 | 3.9% |
| 036000162905 | 5 | 3.3% |
| 078742333960 | 2 | 1.3% |
| 037466017631 | 2 | 1.3% |
| 085718300512 | 2 | 1.3% |
| 021000040247 | 2 | 1.3% |
| 4011 | 2 | 1.3% |
| 078742112138 | 2 | 1.3% |
| 011594404013 | 1 | 0.7% |
| Other values (37) | 37 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 275 | |
| 2 | 162 | |
| 3 | 161 | |
| 4 | 151 | |
| 1 | 101 | 9.4% |
| 6 | 57 | 5.3% |
| 7 | 50 | 4.6% |
| 8 | 47 | 4.4% |
| 5 | 45 | 4.2% |
| 9 | 27 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1076 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 275 | |
| 2 | 162 | |
| 3 | 161 | |
| 4 | 151 | |
| 1 | 101 | 9.4% |
| 6 | 57 | 5.3% |
| 7 | 50 | 4.6% |
| 8 | 47 | 4.4% |
| 5 | 45 | 4.2% |
| 9 | 27 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1076 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 275 | |
| 2 | 162 | |
| 3 | 161 | |
| 4 | 151 | |
| 1 | 101 | 9.4% |
| 6 | 57 | 5.3% |
| 7 | 50 | 4.6% |
| 8 | 47 | 4.4% |
| 5 | 45 | 4.2% |
| 9 | 27 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1076 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 275 | |
| 2 | 162 | |
| 3 | 161 | |
| 4 | 151 | |
| 1 | 101 | 9.4% |
| 6 | 57 | 5.3% |
| 7 | 50 | 4.6% |
| 8 | 47 | 4.4% |
| 5 | 45 | 4.2% |
| 9 | 27 | 2.5% |
originalMetaBriteQuantityPurchased
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 7366 |
| Missing (%) | 99.8% |
| Memory size | 57.8 KiB |
| 1.0 | |
|---|---|
| 2.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 2.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 12 | 0.2% |
| 2.0 | 3 | < 0.1% |
| (Missing) | 7366 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 12 | |
| 2.0 | 3 | 20.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 15 | |
| 0 | 15 | |
| 1 | 12 | |
| 2 | 3 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 15 | |
| 0 | 15 | |
| 1 | 12 | |
| 2 | 3 | 6.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 15 | |
| 0 | 15 | |
| 1 | 12 | |
| 2 | 3 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 15 | |
| 0 | 15 | |
| 1 | 12 | |
| 2 | 3 | 6.7% |
pointsEarned
Real number (ℝ)
High correlation  Missing 
| Distinct | 277 |
|---|---|
| Distinct (%) | 29.9% |
| Missing | 6454 |
| Missing (%) | 87.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 140.50831 |
| Minimum | 4.5 |
|---|---|
| Maximum | 870 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 4.5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 28.05 |
| median | 50 |
| Q3 | 165.45 |
| 95-th percentile | 870 |
| Maximum | 870 |
| Range | 865.5 |
| Interquartile range (IQR) | 137.4 |
Descriptive statistics
| Standard deviation | 223.00559 |
|---|---|
| Coefficient of variation (CV) | 1.5871346 |
| Kurtosis | 5.959663 |
| Mean | 140.50831 |
| Median Absolute Deviation (MAD) | 30.1 |
| Skewness | 2.6550999 |
| Sum | 130251.2 |
| Variance | 49731.495 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 123 | 1.7% |
| 210 | 89 | 1.2% |
| 870 | 70 | 0.9% |
| 5 | 70 | 0.9% |
| 25 | 60 | 0.8% |
| 30 | 40 | 0.5% |
| 34.9 | 21 | 0.3% |
| 55.9 | 20 | 0.3% |
| 10 | 19 | 0.3% |
| 19.9 | 13 | 0.2% |
| Other values (267) | 402 | 5.4% |
| (Missing) | 6454 |
| Value | Count | Frequency (%) |
| 4.5 | 1 | < 0.1% |
| 5 | 70 | |
| 10 | 19 | 0.3% |
| 12.5 | 3 | < 0.1% |
| 12.9 | 1 | < 0.1% |
| 15 | 2 | < 0.1% |
| 16.2 | 1 | < 0.1% |
| 16.3 | 1 | < 0.1% |
| 16.5 | 1 | < 0.1% |
| 16.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 870 | 70 | |
| 844.2 | 2 | < 0.1% |
| 294 | 1 | < 0.1% |
| 292 | 1 | < 0.1% |
| 289 | 1 | < 0.1% |
| 287 | 1 | < 0.1% |
| 285.5 | 1 | < 0.1% |
| 280 | 3 | < 0.1% |
| 277.5 | 1 | < 0.1% |
| 274 | 1 | < 0.1% |
targetPrice
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 7003 |
| Missing (%) | 94.9% |
| Memory size | 57.8 KiB |
| 800 | |
|---|---|
| 77 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.7910053 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 800 |
|---|---|
| 2nd row | 800 |
| 3rd row | 800 |
| 4th row | 800 |
| 5th row | 800 |
Common Values
| Value | Count | Frequency (%) |
| 800 | 299 | 4.1% |
| 77 | 79 | 1.1% |
| (Missing) | 7003 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 800 | 299 | |
| 77 | 79 | 20.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 598 | |
| 8 | 299 | |
| 7 | 158 | 15.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1055 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 598 | |
| 8 | 299 | |
| 7 | 158 | 15.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1055 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 598 | |
| 8 | 299 | |
| 7 | 158 | 15.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1055 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 598 | |
| 8 | 299 | |
| 7 | 158 | 15.0% |
competitiveProduct
Boolean
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 6736 |
| Missing (%) | 91.3% |
| Memory size | 57.8 KiB |
| True | 468 |
|---|---|
| False | 177 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 468 | 6.3% |
| False | 177 | 2.4% |
| (Missing) | 6736 |
originalFinalPrice
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 22.2% |
| Missing | 7372 |
| Missing (%) | 99.9% |
| Memory size | 57.8 KiB |
| 1.00 | |
|---|---|
| 10.00 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.3333333 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.00 |
|---|---|
| 2nd row | 1.00 |
| 3rd row | 10.00 |
| 4th row | 1.00 |
| 5th row | 1.00 |
Common Values
| Value | Count | Frequency (%) |
| 1.00 | 6 | 0.1% |
| 10.00 | 3 | < 0.1% |
| (Missing) | 7372 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.00 | 6 | |
| 10.00 | 3 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
originalMetaBriteItemPrice
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 22.2% |
| Missing | 7372 |
| Missing (%) | 99.9% |
| Memory size | 57.8 KiB |
| 1.00 | |
|---|---|
| 10.00 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.3333333 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.00 |
|---|---|
| 2nd row | 1.00 |
| 3rd row | 10.00 |
| 4th row | 1.00 |
| 5th row | 1.00 |
Common Values
| Value | Count | Frequency (%) |
| 1.00 | 6 | 0.1% |
| 10.00 | 3 | < 0.1% |
| (Missing) | 7372 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.00 | 6 | |
| 10.00 | 3 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21 | |
| 1 | 9 | |
| . | 9 |
deleted
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 7372 |
| Missing (%) | 99.9% |
| Memory size | 57.8 KiB |
| True | 9 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 9 | 0.1% |
| (Missing) | 7372 |
priceAfterCoupon
Real number (ℝ)
High correlation  Missing 
| Distinct | 334 |
|---|---|
| Distinct (%) | 34.9% |
| Missing | 6425 |
| Missing (%) | 87.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.393358 |
| Minimum | 0.19 |
|---|---|
| Maximum | 245 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0.19 |
|---|---|
| 5-th percentile | 0.56 |
| Q1 | 2.685 |
| median | 4.99 |
| Q3 | 11.99 |
| 95-th percentile | 28.57 |
| Maximum | 245 |
| Range | 244.81 |
| Interquartile range (IQR) | 9.305 |
Descriptive statistics
| Standard deviation | 18.695615 |
|---|---|
| Coefficient of variation (CV) | 1.7988041 |
| Kurtosis | 75.037528 |
| Mean | 10.393358 |
| Median Absolute Deviation (MAD) | 3.2 |
| Skewness | 7.4840527 |
| Sum | 9936.05 |
| Variance | 349.52601 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 28.57 | 50 | 0.7% |
| 11.99 | 47 | 0.6% |
| 22.97 | 44 | 0.6% |
| 3.99 | 39 | 0.5% |
| 1 | 25 | 0.3% |
| 5.99 | 24 | 0.3% |
| 0.56 | 23 | 0.3% |
| 2.99 | 21 | 0.3% |
| 4.99 | 20 | 0.3% |
| 3.49 | 20 | 0.3% |
| Other values (324) | 643 | 8.7% |
| (Missing) | 6425 |
| Value | Count | Frequency (%) |
| 0.19 | 2 | < 0.1% |
| 0.5 | 20 | |
| 0.54 | 8 | 0.1% |
| 0.56 | 23 | |
| 0.6 | 1 | < 0.1% |
| 0.77 | 2 | < 0.1% |
| 0.79 | 2 | < 0.1% |
| 0.8 | 1 | < 0.1% |
| 0.88 | 4 | 0.1% |
| 0.89 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 245 | 1 | |
| 223.36 | 2 | |
| 180 | 1 | |
| 168.84 | 1 | |
| 115.96 | 1 | |
| 100 | 2 | |
| 95.84 | 2 | |
| 80 | 1 | |
| 79.84 | 1 | |
| 56 | 2 |
Missing 
| Distinct | 75 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 6518 |
| Missing (%) | 88.3% |
| Memory size | 57.8 KiB |
Length
| Max length | 66 |
|---|---|
| Median length | 46 |
| Mean length | 28.724218 |
| Min length | 11 |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | 3.5% |
Sample
| 1st row | KRAFT SINGLES |
|---|---|
| 2nd row | JUST BARE FRESH CHICKEN BREAST FILETS |
| 3rd row | JUST BARE FRESH CHICKEN BREAST FILETS |
| 4th row | DORITOS NACHO CHEESE MULTI SERVE |
| 5th row | DORITOS NACHO CHEESE MULTI SERVE |
| Value | Count | Frequency (%) |
| and | 207 | 4.6% |
| 200 | 4.4% | |
| cream | 186 | 4.1% |
| 12 | 183 | 4.0% |
| ice | 181 | 4.0% |
| ben | 180 | 4.0% |
| jerrys | 180 | 4.0% |
| pack | 173 | 3.8% |
| cheese | 123 | 2.7% |
| serve | 113 | 2.5% |
| Other values (195) | 2813 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3676 | ||
| E | 3048 | |
| R | 1710 | 6.9% |
| S | 1691 | 6.8% |
| A | 1628 | 6.6% |
| C | 1412 | 5.7% |
| I | 1309 | 5.3% |
| N | 1253 | 5.1% |
| T | 942 | 3.8% |
| O | 861 | 3.5% |
| Other values (34) | 7259 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24789 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3676 | ||
| E | 3048 | |
| R | 1710 | 6.9% |
| S | 1691 | 6.8% |
| A | 1628 | 6.6% |
| C | 1412 | 5.7% |
| I | 1309 | 5.3% |
| N | 1253 | 5.1% |
| T | 942 | 3.8% |
| O | 861 | 3.5% |
| Other values (34) | 7259 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24789 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3676 | ||
| E | 3048 | |
| R | 1710 | 6.9% |
| S | 1691 | 6.8% |
| A | 1628 | 6.6% |
| C | 1412 | 5.7% |
| I | 1309 | 5.3% |
| N | 1253 | 5.1% |
| T | 942 | 3.8% |
| O | 861 | 3.5% |
| Other values (34) | 7259 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24789 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3676 | ||
| E | 3048 | |
| R | 1710 | 6.9% |
| S | 1691 | 6.8% |
| A | 1628 | 6.6% |
| C | 1412 | 5.7% |
| I | 1309 | 5.3% |
| N | 1253 | 5.1% |
| T | 942 | 3.8% |
| O | 861 | 3.5% |
| Other values (34) | 7259 |
receipt_item_id
Text
Unique 
| Distinct | 7381 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.8 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 27 |
| Mean length | 26.988619 |
| Min length | 26 |
Unique
| Unique | 7381 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 5ff1e1cd0a720f052300056f_1 |
|---|---|
| 2nd row | 5ff5d1f20a720f05230005db_1 |
| 3rd row | 5ff5d1f20a720f05230005db_2 |
| 4th row | 5ff5d1f20a720f05230005db_3 |
| 5th row | 5ff5d1f20a720f05230005db_4 |
| Value | Count | Frequency (%) |
| 5ff1e1cd0a720f052300056f_1 | 1 | < 0.1% |
| 5ffe22a20a720f05ac0061d7_1 | 1 | < 0.1% |
| 5ff5d1f20a720f05230005db_2 | 1 | < 0.1% |
| 5ff5d1f20a720f05230005db_3 | 1 | < 0.1% |
| 5ff5d1f20a720f05230005db_4 | 1 | < 0.1% |
| 5ff74fd10a720f0523000619_1 | 1 | < 0.1% |
| 5ff7942e0a720f0523000637_1 | 1 | < 0.1% |
| 5ff7942e0a720f0523000637_2 | 1 | < 0.1% |
| 5ff8da390a7214adca000013_1 | 1 | < 0.1% |
| 5ff8da620a7214adca00001d_1 | 1 | < 0.1% |
| Other values (7371) | 7371 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 62920 | |
| 2 | 16136 | 8.1% |
| a | 15529 | 7.8% |
| f | 11783 | 5.9% |
| 7 | 11185 | 5.6% |
| 1 | 10606 | 5.3% |
| 5 | 10473 | 5.3% |
| 3 | 9720 | 4.9% |
| 6 | 9486 | 4.8% |
| _ | 7381 | 3.7% |
| Other values (7) | 33984 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 199203 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62920 | |
| 2 | 16136 | 8.1% |
| a | 15529 | 7.8% |
| f | 11783 | 5.9% |
| 7 | 11185 | 5.6% |
| 1 | 10606 | 5.3% |
| 5 | 10473 | 5.3% |
| 3 | 9720 | 4.9% |
| 6 | 9486 | 4.8% |
| _ | 7381 | 3.7% |
| Other values (7) | 33984 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 199203 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62920 | |
| 2 | 16136 | 8.1% |
| a | 15529 | 7.8% |
| f | 11783 | 5.9% |
| 7 | 11185 | 5.6% |
| 1 | 10606 | 5.3% |
| 5 | 10473 | 5.3% |
| 3 | 9720 | 4.9% |
| 6 | 9486 | 4.8% |
| _ | 7381 | 3.7% |
| Other values (7) | 33984 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 199203 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 62920 | |
| 2 | 16136 | 8.1% |
| a | 15529 | 7.8% |
| f | 11783 | 5.9% |
| 7 | 11185 | 5.6% |
| 1 | 10606 | 5.3% |
| 5 | 10473 | 5.3% |
| 3 | 9720 | 4.9% |
| 6 | 9486 | 4.8% |
| _ | 7381 | 3.7% |
| Other values (7) | 33984 |
items_in_receipt_list
Real number (ℝ)
High correlation  Missing 
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 464 |
| Missing (%) | 6.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240.01084 |
| Minimum | 1 |
|---|---|
| Maximum | 689 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 93 |
| median | 167 |
| Q3 | 309 |
| 95-th percentile | 689 |
| Maximum | 689 |
| Range | 688 |
| Interquartile range (IQR) | 216 |
Descriptive statistics
| Standard deviation | 221.92227 |
|---|---|
| Coefficient of variation (CV) | 0.92463433 |
| Kurtosis | -0.28839641 |
| Mean | 240.01084 |
| Median Absolute Deviation (MAD) | 136 |
| Skewness | 0.96207664 |
| Sum | 1660155 |
| Variance | 49249.492 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 689 | 459 | 6.2% |
| 1 | 458 | 6.2% |
| 670 | 450 | 6.1% |
| 599 | 381 | 5.2% |
| 5 | 372 | 5.0% |
| 133 | 248 | 3.4% |
| 303 | 217 | 2.9% |
| 214 | 203 | 2.8% |
| 212 | 194 | 2.6% |
| 335 | 185 | 2.5% |
| Other values (39) | 3750 | |
| (Missing) | 464 | 6.3% |
| Value | Count | Frequency (%) |
| 1 | 458 | |
| 2 | 149 | 2.0% |
| 3 | 32 | 0.4% |
| 4 | 174 | 2.4% |
| 5 | 372 | |
| 6 | 23 | 0.3% |
| 7 | 15 | 0.2% |
| 8 | 2 | < 0.1% |
| 9 | 90 | 1.2% |
| 10 | 115 | 1.6% |
| Value | Count | Frequency (%) |
| 689 | 459 | |
| 670 | 450 | |
| 599 | 381 | |
| 348 | 127 | 1.7% |
| 341 | 124 | 1.7% |
| 335 | 185 | |
| 309 | 183 | 2.5% |
| 303 | 217 | |
| 240 | 148 | 2.0% |
| 229 | 99 | 1.3% |
summary_list_difference_count
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 513 |
| Missing (%) | 7.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.064647641 |
| Minimum | -10 |
|---|---|
| Maximum | 4 |
| Zeros | 6756 |
| Zeros (%) | 91.5% |
| Negative | 92 |
| Negative (%) | 1.2% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | -10 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 14 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.81178308 |
|---|---|
| Coefficient of variation (CV) | -12.557041 |
| Kurtosis | 141.21441 |
| Mean | -0.064647641 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -11.677228 |
| Sum | -444 |
| Variance | 0.65899176 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6756 | |
| -1 | 48 | 0.7% |
| -10 | 44 | 0.6% |
| 2 | 16 | 0.2% |
| 4 | 2 | < 0.1% |
| 1 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| (Missing) | 513 | 7.0% |
| Value | Count | Frequency (%) |
| -10 | 44 | 0.6% |
| -1 | 48 | 0.7% |
| 0 | 6756 | |
| 1 | 1 | < 0.1% |
| 2 | 16 | 0.2% |
| 3 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 4 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 2 | 16 | 0.2% |
| 1 | 1 | < 0.1% |
| 0 | 6756 | |
| -1 | 48 | 0.7% |
| -10 | 44 | 0.6% |
hours_diff
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 67 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 1301 |
| Missing (%) | 17.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.4424764 |
| Minimum | 0 |
|---|---|
| Maximum | 1891.8567 |
| Zeros | 439 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.056666667 |
| median | 0.12944444 |
| Q3 | 0.18805556 |
| 95-th percentile | 5.5 |
| Maximum | 1891.8567 |
| Range | 1891.8567 |
| Interquartile range (IQR) | 0.13138889 |
Descriptive statistics
| Standard deviation | 102.9143 |
|---|---|
| Coefficient of variation (CV) | 13.827965 |
| Kurtosis | 240.0396 |
| Mean | 7.4424764 |
| Median Absolute Deviation (MAD) | 0.071944444 |
| Skewness | 15.443841 |
| Sum | 45250.256 |
| Variance | 10591.354 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0002777777778 | 593 | 8.0% |
| 1.181944444 | 459 | 6.2% |
| 5.5 | 450 | 6.1% |
| 0 | 439 | 5.9% |
| 0.1447222222 | 203 | 2.8% |
| 0.2241666667 | 194 | 2.6% |
| 0.1030555556 | 186 | 2.5% |
| 0.1191666667 | 183 | 2.5% |
| 0.1880555556 | 176 | 2.4% |
| 0.1194444444 | 155 | 2.1% |
| Other values (57) | 3042 | |
| (Missing) | 1301 |
| Value | Count | Frequency (%) |
| 0 | 439 | |
| 0.0002777777778 | 593 | |
| 0.0005555555556 | 62 | 0.8% |
| 0.0008333333333 | 14 | 0.2% |
| 0.001111111111 | 8 | 0.1% |
| 0.001388888889 | 2 | < 0.1% |
| 0.001666666667 | 7 | 0.1% |
| 0.001944444444 | 10 | 0.1% |
| 0.002222222222 | 9 | 0.1% |
| 0.0025 | 13 | 0.2% |
| Value | Count | Frequency (%) |
| 1891.856667 | 5 | |
| 1555.365 | 5 | |
| 1537.339444 | 5 | |
| 1440.754722 | 11 | |
| 102.0030556 | 4 | 0.1% |
| 72.58861111 | 1 | < 0.1% |
| 48.00277778 | 2 | < 0.1% |
| 48.00166667 | 1 | < 0.1% |
| 48.00111111 | 2 | < 0.1% |
| 48.00083333 | 1 | < 0.1% |
minutes_diff
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 67 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 1301 |
| Missing (%) | 17.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 446.54858 |
| Minimum | 0 |
|---|---|
| Maximum | 113511.4 |
| Zeros | 439 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 57.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.4 |
| median | 7.7666667 |
| Q3 | 11.283333 |
| 95-th percentile | 330 |
| Maximum | 113511.4 |
| Range | 113511.4 |
| Interquartile range (IQR) | 7.8833333 |
Descriptive statistics
| Standard deviation | 6174.8581 |
|---|---|
| Coefficient of variation (CV) | 13.827965 |
| Kurtosis | 240.0396 |
| Mean | 446.54858 |
| Median Absolute Deviation (MAD) | 4.3166667 |
| Skewness | 15.443841 |
| Sum | 2715015.4 |
| Variance | 38128873 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.01666666667 | 593 | 8.0% |
| 70.91666667 | 459 | 6.2% |
| 330 | 450 | 6.1% |
| 0 | 439 | 5.9% |
| 8.683333333 | 203 | 2.8% |
| 13.45 | 194 | 2.6% |
| 6.183333333 | 186 | 2.5% |
| 7.15 | 183 | 2.5% |
| 11.28333333 | 176 | 2.4% |
| 7.166666667 | 155 | 2.1% |
| Other values (57) | 3042 | |
| (Missing) | 1301 |
| Value | Count | Frequency (%) |
| 0 | 439 | |
| 0.01666666667 | 593 | |
| 0.03333333333 | 62 | 0.8% |
| 0.05 | 14 | 0.2% |
| 0.06666666667 | 8 | 0.1% |
| 0.08333333333 | 2 | < 0.1% |
| 0.1 | 7 | 0.1% |
| 0.1166666667 | 10 | 0.1% |
| 0.1333333333 | 9 | 0.1% |
| 0.15 | 13 | 0.2% |
| Value | Count | Frequency (%) |
| 113511.4 | 5 | |
| 93321.9 | 5 | |
| 92240.36667 | 5 | |
| 86445.28333 | 11 | |
| 6120.183333 | 4 | 0.1% |
| 4355.316667 | 1 | < 0.1% |
| 2880.166667 | 2 | < 0.1% |
| 2880.1 | 1 | < 0.1% |
| 2880.066667 | 2 | < 0.1% |
| 2880.05 | 1 | < 0.1% |
Interactions
Correlations
| competitiveProduct | competitorRewardsGroup | discountedItemPrice | finalPrice | hours_diff | itemNumber | itemPrice | items_in_receipt_list | minutes_diff | needsFetchReview | needsFetchReviewReason | originalFinalPrice | originalMetaBriteBarcode | originalMetaBriteDescription | originalMetaBriteItemPrice | originalMetaBriteQuantityPurchased | partnerItemId | pointsEarned | pointsPayerId | priceAfterCoupon | purchasedItemCount | quantityPurchased | rewardsProductPartnerId | summary_list_difference_count | targetPrice | total_receipt_points_earned | total_receipt_spent | userFlaggedBarcode | userFlaggedDescription | userFlaggedPrice | userFlaggedQuantity | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| competitiveProduct | 1.000 | 1.000 | 0.768 | 0.813 | 0.000 | 1.000 | 0.081 | 0.432 | 0.000 | 0.000 | 0.593 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.561 | 0.734 | 0.237 | 0.642 | 0.432 | 0.235 | 0.647 | 0.000 | 1.000 | 0.382 | 0.427 | 1.000 | 0.000 | 1.000 | 1.000 |
| competitorRewardsGroup | 1.000 | 1.000 | 0.709 | 0.709 | 1.000 | NaN | 0.000 | 0.240 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.389 | 0.000 | 0.000 | 0.621 | 0.234 | 0.198 | 0.869 | 1.000 | 0.000 | 0.045 | 0.242 | 0.000 | 0.000 | 0.000 | 0.000 |
| discountedItemPrice | 0.768 | 0.709 | 1.000 | 1.000 | -0.044 | 0.924 | 1.000 | -0.018 | -0.044 | 0.812 | 1.000 | 0.000 | 0.442 | 0.000 | 0.000 | 1.000 | -0.035 | 0.967 | 0.342 | 1.000 | 0.005 | 0.431 | 0.454 | NaN | 0.000 | 0.037 | -0.005 | 0.000 | 0.000 | 0.000 | 0.000 |
| finalPrice | 0.813 | 0.709 | 1.000 | 1.000 | -0.105 | 0.924 | 1.000 | -0.081 | -0.105 | 0.479 | 0.875 | 0.707 | 0.641 | 0.762 | 0.707 | 0.961 | -0.103 | 0.939 | 0.541 | 1.000 | -0.064 | 0.398 | 0.528 | 0.049 | 0.988 | 0.005 | -0.049 | 0.830 | 0.866 | 0.943 | 0.432 |
| hours_diff | 0.000 | 1.000 | -0.044 | -0.105 | 1.000 | 1.000 | -0.104 | 0.752 | 1.000 | 0.086 | 1.000 | 0.000 | 0.664 | 0.935 | 0.000 | 0.160 | 0.624 | 0.124 | 0.445 | -0.009 | 0.752 | 0.039 | 0.384 | 0.115 | 0.997 | 0.696 | 0.766 | 0.160 | 1.000 | 0.232 | 0.011 |
| itemNumber | 1.000 | NaN | 0.924 | 0.924 | 1.000 | 1.000 | 0.838 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.361 | 0.000 | 0.000 | 1.000 | 0.923 | 0.918 | 0.967 | 0.000 | 1.000 | 0.838 | 0.911 | 1.000 | 0.000 | 0.838 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| itemPrice | 0.081 | 0.000 | 1.000 | 1.000 | -0.104 | 0.838 | 1.000 | -0.080 | -0.104 | 0.242 | 0.989 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | -0.103 | 0.939 | 0.207 | 1.000 | -0.064 | 0.398 | 0.000 | 0.049 | 1.000 | 0.005 | -0.049 | 1.000 | 1.000 | 1.000 | 1.000 |
| items_in_receipt_list | 0.432 | 0.240 | -0.018 | -0.081 | 0.752 | 1.000 | -0.080 | 1.000 | 0.752 | 0.671 | 0.358 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.696 | 0.115 | 0.331 | -0.313 | 0.999 | 0.202 | 0.261 | 0.141 | 1.000 | 0.786 | 0.938 | 1.000 | 1.000 | 1.000 | 1.000 |
| minutes_diff | 0.000 | 1.000 | -0.044 | -0.105 | 1.000 | 1.000 | -0.104 | 0.752 | 1.000 | 0.086 | 1.000 | 0.000 | 0.664 | 0.935 | 0.000 | 0.160 | 0.624 | 0.124 | 0.445 | -0.009 | 0.752 | 0.039 | 0.384 | 0.115 | 0.997 | 0.696 | 0.766 | 0.160 | 1.000 | 0.232 | 0.011 |
| needsFetchReview | 0.000 | 1.000 | 0.812 | 0.479 | 0.086 | 1.000 | 0.242 | 0.671 | 0.086 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.380 | 0.482 | 0.328 | NaN | 0.679 | 0.219 | 0.372 | 0.554 | 1.000 | 0.701 | 0.679 | 0.713 | 1.000 | 0.553 | 0.481 |
| needsFetchReviewReason | 0.593 | 0.000 | 1.000 | 0.875 | 1.000 | 1.000 | 0.989 | 0.358 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.596 | 0.671 | 0.956 | NaN | 0.360 | 0.854 | 0.947 | 0.072 | 0.000 | 0.468 | 0.360 | 1.000 | 1.000 | 1.000 | 1.000 |
| originalFinalPrice | 1.000 | 0.000 | 0.000 | 0.707 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.707 | 1.000 | 0.707 | 0.707 | 0.926 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.707 | 1.000 | 1.000 | 1.000 | 1.000 | 0.707 | 0.000 | 0.707 | 0.707 |
| originalMetaBriteBarcode | 1.000 | 0.000 | 0.442 | 0.641 | 0.664 | 0.361 | 1.000 | 1.000 | 0.664 | 1.000 | 0.000 | 0.707 | 1.000 | 0.762 | 0.707 | 0.707 | 0.277 | 0.853 | 0.742 | 0.000 | 1.000 | 1.000 | 0.694 | 1.000 | 0.856 | 0.311 | 1.000 | 1.000 | 0.000 | 0.707 | 0.707 |
| originalMetaBriteDescription | 0.000 | 0.000 | 0.000 | 0.762 | 0.935 | 0.000 | 1.000 | 1.000 | 0.935 | 1.000 | 0.000 | 1.000 | 0.762 | 1.000 | 1.000 | 1.000 | 0.935 | 1.000 | 0.762 | 0.000 | 1.000 | 1.000 | 0.762 | 1.000 | 1.000 | 0.415 | 1.000 | 0.762 | 0.000 | 1.000 | 1.000 |
| originalMetaBriteItemPrice | 1.000 | 0.000 | 0.000 | 0.707 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.707 | 0.707 | 1.000 | 1.000 | 0.707 | 0.926 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.707 | 1.000 | 1.000 | 1.000 | 1.000 | 0.707 | 0.000 | 0.707 | 0.707 |
| originalMetaBriteQuantityPurchased | 1.000 | 0.000 | 1.000 | 0.961 | 0.160 | 1.000 | 0.000 | 1.000 | 0.160 | 0.000 | 1.000 | 0.707 | 0.707 | 1.000 | 0.707 | 1.000 | 0.920 | 1.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.961 | 1.000 | 1.000 | 1.000 | 1.000 | 0.707 | 0.000 | 0.707 | 0.707 |
| partnerItemId | 0.561 | 0.389 | -0.035 | -0.103 | 0.624 | 0.923 | -0.103 | 0.696 | 0.624 | 0.380 | 0.596 | 0.926 | 0.277 | 0.935 | 0.926 | 0.920 | 1.000 | 0.052 | 0.496 | -0.171 | 0.693 | 0.150 | 0.378 | 0.107 | 0.408 | 0.585 | 0.686 | 0.544 | 0.561 | 0.345 | 0.371 |
| pointsEarned | 0.734 | 0.000 | 0.967 | 0.939 | 0.124 | 0.918 | 0.939 | 0.115 | 0.124 | 0.482 | 0.671 | 1.000 | 0.853 | 1.000 | 1.000 | 1.000 | 0.052 | 1.000 | 0.620 | 0.958 | 0.115 | 0.331 | 0.620 | NaN | 0.992 | 0.499 | 0.328 | 0.987 | 1.000 | 0.922 | 1.000 |
| pointsPayerId | 0.237 | 0.000 | 0.342 | 0.541 | 0.445 | 0.967 | 0.207 | 0.331 | 0.445 | 0.328 | 0.956 | 1.000 | 0.742 | 0.762 | 1.000 | 1.000 | 0.496 | 0.620 | 1.000 | 0.368 | 0.331 | 0.226 | 1.000 | 1.000 | 0.996 | 0.381 | 0.427 | 0.991 | 0.862 | 0.987 | 1.000 |
| priceAfterCoupon | 0.642 | 0.621 | 1.000 | 1.000 | -0.009 | 0.000 | 1.000 | -0.313 | -0.009 | NaN | NaN | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | -0.171 | 0.958 | 0.368 | 1.000 | -0.207 | 0.374 | 0.409 | NaN | 0.000 | -0.223 | -0.312 | 0.000 | 0.000 | 0.000 | 0.000 |
| purchasedItemCount | 0.432 | 0.234 | 0.005 | -0.064 | 0.752 | 1.000 | -0.064 | 0.999 | 0.752 | 0.679 | 0.360 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.693 | 0.115 | 0.331 | -0.207 | 1.000 | 0.198 | 0.261 | 0.101 | 1.000 | 0.788 | 0.937 | 1.000 | 1.000 | 1.000 | 1.000 |
| quantityPurchased | 0.235 | 0.198 | 0.431 | 0.398 | 0.039 | 0.838 | 0.398 | 0.202 | 0.039 | 0.219 | 0.854 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.150 | 0.331 | 0.226 | 0.374 | 0.198 | 1.000 | 0.218 | 0.065 | 0.047 | 0.231 | 0.133 | 0.318 | 0.520 | 0.357 | 0.701 |
| rewardsProductPartnerId | 0.647 | 0.869 | 0.454 | 0.528 | 0.384 | 0.911 | 0.000 | 0.261 | 0.384 | 0.372 | 0.947 | 0.707 | 0.694 | 0.762 | 0.707 | 0.961 | 0.378 | 0.620 | 1.000 | 0.409 | 0.261 | 0.218 | 1.000 | 0.000 | 0.996 | 0.352 | 0.331 | 0.992 | 0.862 | 0.692 | 0.990 |
| summary_list_difference_count | 0.000 | 1.000 | NaN | 0.049 | 0.115 | 1.000 | 0.049 | 0.141 | 0.115 | 0.554 | 0.072 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.107 | NaN | 1.000 | NaN | 0.101 | 0.065 | 0.000 | 1.000 | 1.000 | 0.075 | 0.137 | 0.525 | 0.635 | 0.630 | 0.370 |
| targetPrice | 1.000 | 0.000 | 0.000 | 0.988 | 0.997 | 0.000 | 1.000 | 1.000 | 0.997 | 1.000 | 0.000 | 1.000 | 0.856 | 1.000 | 1.000 | 1.000 | 0.408 | 0.992 | 0.996 | 0.000 | 1.000 | 0.047 | 0.996 | 1.000 | 1.000 | 0.924 | 1.000 | 0.985 | 0.000 | 0.978 | 1.000 |
| total_receipt_points_earned | 0.382 | 0.045 | 0.037 | 0.005 | 0.696 | 0.838 | 0.005 | 0.786 | 0.696 | 0.701 | 0.468 | 1.000 | 0.311 | 0.415 | 1.000 | 1.000 | 0.585 | 0.499 | 0.381 | -0.223 | 0.788 | 0.231 | 0.352 | 0.075 | 0.924 | 1.000 | 0.740 | 0.105 | 0.391 | 0.195 | 0.150 |
| total_receipt_spent | 0.427 | 0.242 | -0.005 | -0.049 | 0.766 | 1.000 | -0.049 | 0.938 | 0.766 | 0.679 | 0.360 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.686 | 0.328 | 0.427 | -0.312 | 0.937 | 0.133 | 0.331 | 0.137 | 1.000 | 0.740 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| userFlaggedBarcode | 1.000 | 0.000 | 0.000 | 0.830 | 0.160 | 0.000 | 1.000 | 1.000 | 0.160 | 0.713 | 1.000 | 0.707 | 1.000 | 0.762 | 0.707 | 0.707 | 0.544 | 0.987 | 0.991 | 0.000 | 1.000 | 0.318 | 0.992 | 0.525 | 0.985 | 0.105 | 1.000 | 1.000 | 0.998 | 0.802 | 0.520 |
| userFlaggedDescription | 0.000 | 0.000 | 0.000 | 0.866 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.561 | 1.000 | 0.862 | 0.000 | 1.000 | 0.520 | 0.862 | 0.635 | 0.000 | 0.391 | 1.000 | 0.998 | 1.000 | 0.882 | 0.529 |
| userFlaggedPrice | 1.000 | 0.000 | 0.000 | 0.943 | 0.232 | 0.000 | 1.000 | 1.000 | 0.232 | 0.553 | 1.000 | 0.707 | 0.707 | 1.000 | 0.707 | 0.707 | 0.345 | 0.922 | 0.987 | 0.000 | 1.000 | 0.357 | 0.692 | 0.630 | 0.978 | 0.195 | 1.000 | 0.802 | 0.882 | 1.000 | 0.479 |
| userFlaggedQuantity | 1.000 | 0.000 | 0.000 | 0.432 | 0.011 | 0.000 | 1.000 | 1.000 | 0.011 | 0.481 | 1.000 | 0.707 | 0.707 | 1.000 | 0.707 | 0.707 | 0.371 | 1.000 | 1.000 | 0.000 | 1.000 | 0.701 | 0.990 | 0.370 | 1.000 | 0.150 | 1.000 | 0.520 | 0.529 | 0.479 | 1.000 |
Missing values
Sample
| receipt_id | purchasedItemCount | createdate | datescanned | finisheddate | modifydate | pointsawardeddate | purchasedate | total_receipt_points_earned | total_receipt_spent | barcode | description | finalPrice | itemPrice | needsFetchReview | partnerItemId | preventTargetGapPoints | quantityPurchased | userFlaggedBarcode | userFlaggedNewItem | userFlaggedPrice | userFlaggedQuantity | needsFetchReviewReason | pointsNotAwardedReason | pointsPayerId | rewardsGroup | rewardsProductPartnerId | userFlaggedDescription | originalMetaBriteBarcode | originalMetaBriteDescription | brandCode | competitorRewardsGroup | discountedItemPrice | originalReceiptItemText | itemNumber | originalMetaBriteQuantityPurchased | pointsEarned | targetPrice | competitiveProduct | originalFinalPrice | originalMetaBriteItemPrice | deleted | priceAfterCoupon | metabriteCampaignId | receipt_item_id | items_in_receipt_list | summary_list_difference_count | hours_diff | minutes_diff | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5ff1e1cd0a720f052300056f | 1.0 | 2021-01-03 15:25:01 | 2021-01-03 15:25:01 | 2021-01-03 15:25:02 | 2021-01-03 15:25:02 | 2021-01-03 15:25:02 | 2021-01-03 15:25:01 | 5.0 | 2.230000 | None | MSSN TORTLLA | 2.23 | 2.23 | NaN | 1009 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | MISSION | TACO BELL TACO SHELLS | 2.23 | MSSN TORTLLA | None | NaN | None | None | NaN | None | None | NaN | None | None | 5ff1e1cd0a720f052300056f_1 | 1.0 | 0.0 | 0.000278 | 0.016667 |
| 1 | 5ff5d1f20a720f05230005db | 4.0 | 2021-01-06 15:06:26 | 2021-01-06 15:06:26 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-05 15:06:26 | 5.0 | 18.200001 | 021000051113 | None | 4.55 | 4.55 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | SARGENTO GRATED PARMESAN CHEESE | 5e7cf838f221c312e698a628 | None | None | None | None | None | None | None | None | NaN | None | None | True | None | None | NaN | None | None | 5ff5d1f20a720f05230005db_1 | 4.0 | 0.0 | 0.000278 | 0.016667 |
| 2 | 5ff5d1f20a720f05230005db | 4.0 | 2021-01-06 15:06:26 | 2021-01-06 15:06:26 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-05 15:06:26 | 5.0 | 18.200001 | 021000051113 | None | 4.55 | 4.55 | NaN | 2 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | SARGENTO GRATED PARMESAN CHEESE | 5e7cf838f221c312e698a628 | None | None | None | None | None | None | None | None | NaN | None | None | True | None | None | NaN | None | None | 5ff5d1f20a720f05230005db_2 | 4.0 | 0.0 | 0.000278 | 0.016667 |
| 3 | 5ff5d1f20a720f05230005db | 4.0 | 2021-01-06 15:06:26 | 2021-01-06 15:06:26 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-05 15:06:26 | 5.0 | 18.200001 | 021000051113 | None | 4.55 | 4.55 | NaN | 3 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | SARGENTO GRATED PARMESAN CHEESE | 5e7cf838f221c312e698a628 | None | None | None | None | None | None | None | None | NaN | None | None | True | None | None | NaN | None | None | 5ff5d1f20a720f05230005db_3 | 4.0 | 0.0 | 0.000278 | 0.016667 |
| 4 | 5ff5d1f20a720f05230005db | 4.0 | 2021-01-06 15:06:26 | 2021-01-06 15:06:26 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-06 15:06:27 | 2021-01-05 15:06:26 | 5.0 | 18.200001 | 021000051113 | None | 4.55 | 4.55 | NaN | 4 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | SARGENTO GRATED PARMESAN CHEESE | 5e7cf838f221c312e698a628 | None | None | None | None | None | None | None | None | NaN | None | None | True | None | None | NaN | None | None | 5ff5d1f20a720f05230005db_4 | 4.0 | 0.0 | 0.000278 | 0.016667 |
| 5 | 5ff74fd10a720f0523000619 | 1.0 | 2021-01-07 18:15:45 | 2021-01-07 18:15:45 | 2021-01-07 18:15:47 | 2021-01-07 18:15:47 | 2021-01-07 18:15:47 | 2021-01-06 18:15:45 | 5.0 | 1.000000 | 043000204399 | Jell-O Instant Pudding & Pie Filling French Vanilla, 3.4 Oz | 1 | 1.00 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | 559c2234e4b06aca36af13c6 | None | None | None | None | None | None | None | None | NaN | None | None | NaN | None | None | NaN | None | None | 5ff74fd10a720f0523000619_1 | 1.0 | 0.0 | 0.000556 | 0.033333 |
| 6 | 5ff7942e0a720f0523000637 | 2.0 | 2021-01-05 23:07:26 | 2021-01-05 23:07:26 | 2021-01-07 23:07:36 | 2021-01-07 23:07:36 | 2021-01-07 05:07:29 | 2021-01-04 23:07:26 | 2005.0 | 1.000000 | 1234 | None | None | NaN | True | 2 | True | NaN | 1234 | True | None | NaN | USER_FLAGGED | None | None | None | None | None | None | None | None | None | None | None | NaN | None | None | NaN | None | None | NaN | None | None | 5ff7942e0a720f0523000637_1 | 1.0 | -1.0 | 30.000833 | 1800.050000 | |
| 7 | 5ff7942e0a720f0523000637 | 2.0 | 2021-01-05 23:07:26 | 2021-01-05 23:07:26 | 2021-01-07 23:07:36 | 2021-01-07 23:07:36 | 2021-01-07 05:07:29 | 2021-01-04 23:07:26 | 2005.0 | 1.000000 | 4011 | ITEM NOT FOUND | 1 | 1.00 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | NaN | None | None | NaN | None | None | NaN | None | None | 5ff7942e0a720f0523000637_2 | 1.0 | -1.0 | 30.000833 | 1800.050000 |
| 8 | 5ff8da390a7214adca000013 | 1.0 | 2021-01-08 22:18:33 | 2021-01-08 22:18:33 | 2021-01-08 22:18:34 | 2021-01-08 22:18:34 | 2021-01-08 22:18:34 | 2021-01-01 00:00:00 | 350.0 | 10.000000 | 305210154278 | VASELINE COCOA BUTTER SKIN MOISTURIZER LOTION CONDITIONING RP 34.5 OZ | 10.00 | 10.00 | NaN | 0 | NaN | 1.0 | None | NaN | None | NaN | None | None | 5332f5f6e4b03c9a25efd0b4 | VASELINE HAND AND BODY LOTION | 5332f5f6e4b03c9a25efd0b4 | None | None | None | BRAND | None | None | None | None | NaN | 100.0 | None | NaN | None | None | NaN | None | None | 5ff8da390a7214adca000013_1 | 1.0 | 0.0 | 0.000278 | 0.016667 |
| 9 | 5ff8da620a7214adca00001d | 1.0 | 2021-01-08 22:19:14 | 2021-01-08 22:19:14 | NaT | 2021-01-08 22:19:15 | 2021-01-08 22:19:14 | 2021-01-07 22:19:14 | 750.0 | 1.000000 | 075925306254 | None | 1 | 1.00 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | SARGENTO NATURAL SHREDDED CHEESE 6OZ OR LARGER | 5e7cf838f221c312e698a628 | None | None | None | None | None | None | None | None | NaN | None | None | True | None | None | NaN | None | None | 5ff8da620a7214adca00001d_1 | 1.0 | 0.0 | 0.000000 | 0.000000 |
| receipt_id | purchasedItemCount | createdate | datescanned | finisheddate | modifydate | pointsawardeddate | purchasedate | total_receipt_points_earned | total_receipt_spent | barcode | description | finalPrice | itemPrice | needsFetchReview | partnerItemId | preventTargetGapPoints | quantityPurchased | userFlaggedBarcode | userFlaggedNewItem | userFlaggedPrice | userFlaggedQuantity | needsFetchReviewReason | pointsNotAwardedReason | pointsPayerId | rewardsGroup | rewardsProductPartnerId | userFlaggedDescription | originalMetaBriteBarcode | originalMetaBriteDescription | brandCode | competitorRewardsGroup | discountedItemPrice | originalReceiptItemText | itemNumber | originalMetaBriteQuantityPurchased | pointsEarned | targetPrice | competitiveProduct | originalFinalPrice | originalMetaBriteItemPrice | deleted | priceAfterCoupon | metabriteCampaignId | receipt_item_id | items_in_receipt_list | summary_list_difference_count | hours_diff | minutes_diff | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7371 | 603aab2f0a7217c72c00023a | 2.0 | 2021-02-27 20:27:27.000 | 2021-02-27 20:27:27.000 | NaT | 2021-02-27 20:27:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B076FJ92M4 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | 22.97 | 22.97 | NaN | 0 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 22.97 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | None | NaN | None | None | NaN | None | None | NaN | 22.97 | None | 603aab2f0a7217c72c00023a_1 | 2.0 | 0.0 | NaN | NaN |
| 7372 | 603aab2f0a7217c72c00023a | 2.0 | 2021-02-27 20:27:27.000 | 2021-02-27 20:27:27.000 | NaT | 2021-02-27 20:27:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B07BRRLSVC | thindust summer face mask - sun protection neck gaiter for outdooractivities | 11.99 | 11.99 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 11.99 | thindust summer face mask - sun protection neck gaiter for outdooractivities | None | NaN | None | None | NaN | None | None | NaN | 11.99 | None | 603aab2f0a7217c72c00023a_2 | 2.0 | 0.0 | NaN | NaN |
| 7373 | 603b77170a7217c72c0002e6 | 2.0 | 2021-02-28 10:57:27.000 | 2021-02-28 10:57:27.000 | NaT | 2021-02-28 10:57:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B076FJ92M4 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | 22.97 | 22.97 | NaN | 0 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 22.97 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | None | NaN | None | None | NaN | None | None | NaN | 22.97 | None | 603b77170a7217c72c0002e6_1 | 2.0 | 0.0 | NaN | NaN |
| 7374 | 603b77170a7217c72c0002e6 | 2.0 | 2021-02-28 10:57:27.000 | 2021-02-28 10:57:27.000 | NaT | 2021-02-28 10:57:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B07BRRLSVC | thindust summer face mask - sun protection neck gaiter for outdooractivities | 11.99 | 11.99 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 11.99 | thindust summer face mask - sun protection neck gaiter for outdooractivities | None | NaN | None | None | NaN | None | None | NaN | 11.99 | None | 603b77170a7217c72c0002e6_2 | 2.0 | 0.0 | NaN | NaN |
| 7375 | 603bdbe10a7217c72c00033e | 2.0 | 2021-02-28 18:07:29.000 | 2021-02-28 18:07:29.000 | NaT | 2021-02-28 18:07:30.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B076FJ92M4 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | 22.97 | 22.97 | NaN | 0 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 22.97 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | None | NaN | None | None | NaN | None | None | NaN | 22.97 | None | 603bdbe10a7217c72c00033e_1 | 2.0 | 0.0 | NaN | NaN |
| 7376 | 603bdbe10a7217c72c00033e | 2.0 | 2021-02-28 18:07:29.000 | 2021-02-28 18:07:29.000 | NaT | 2021-02-28 18:07:30.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B07BRRLSVC | thindust summer face mask - sun protection neck gaiter for outdooractivities | 11.99 | 11.99 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 11.99 | thindust summer face mask - sun protection neck gaiter for outdooractivities | None | NaN | None | None | NaN | None | None | NaN | 11.99 | None | 603bdbe10a7217c72c00033e_2 | 2.0 | 0.0 | NaN | NaN |
| 7377 | 603c4fea0a7217c72c000389 | NaN | 2021-03-01 02:22:34.962 | 2021-03-01 02:22:34.962 | NaT | 2021-03-01 02:22:34.962 | NaT | NaT | NaN | NaN | None | None | None | NaN | NaN | None | NaN | NaN | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | NaN | None | None | NaN | None | None | NaN | None | None | 603c4fea0a7217c72c000389_1 | NaN | NaN | NaN | NaN |
| 7378 | 603ca44a0a720fde100003d0 | NaN | 2021-03-01 08:22:34.244 | 2021-03-01 08:22:34.244 | NaT | 2021-03-01 08:22:34.244 | NaT | NaT | NaN | NaN | None | None | None | NaN | NaN | None | NaN | NaN | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | NaN | None | None | NaN | None | None | NaN | None | None | 603ca44a0a720fde100003d0_1 | NaN | NaN | NaN | NaN |
| 7379 | 603d59e70a7217c72c00045f | 2.0 | 2021-03-01 21:17:27.000 | 2021-03-01 21:17:27.000 | NaT | 2021-03-01 21:17:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B076FJ92M4 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | 22.97 | 22.97 | NaN | 0 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 22.97 | mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white | None | NaN | None | None | NaN | None | None | NaN | 22.97 | None | 603d59e70a7217c72c00045f_1 | 2.0 | 0.0 | NaN | NaN |
| 7380 | 603d59e70a7217c72c00045f | 2.0 | 2021-03-01 21:17:27.000 | 2021-03-01 21:17:27.000 | NaT | 2021-03-01 21:17:28.000 | NaT | 2020-08-17 | 25.0 | 34.959999 | B07BRRLSVC | thindust summer face mask - sun protection neck gaiter for outdooractivities | 11.99 | 11.99 | NaN | 1 | NaN | 1.0 | None | NaN | None | NaN | None | None | None | None | None | None | None | None | None | None | 11.99 | thindust summer face mask - sun protection neck gaiter for outdooractivities | None | NaN | None | None | NaN | None | None | NaN | 11.99 | None | 603d59e70a7217c72c00045f_2 | 2.0 | 0.0 | NaN | NaN |